Duane.
Duane Hennessy
Bandicoot Software
Tropical Queensland, Australia
(ABN: 33 682 969 957)
Your own personal library of code snippets.
http://www.bandicootsoftware.com.au
--- In AccessDevelopers@yahoogroups.com, "Chad Lisowe" <[EMAIL PROTECTED]> wrote:
>
> I am trying to assign a string to a Field Variable so that I can hide
> that field in a Form (DataSheet View). I know I can do it one by one
> but I would like to be a little more efficient.
>
> Here is the Form's Sub
>
> Private Sub HIDE_INVOICE_NUM_Click()
>
> Dim fldInvoiceNum As Field
>
> 'This will be a string concatenated with a recordset variable
> Set fldInvoiceNum = "Forms!frmReportExceptionAudit!INVOICE_NUM"
> fldInvoiceNum.Properties("ColumnHidden") = True
>
> End Sub
>
> Thanks in advance for anyone's help.
>
Please zip all files prior to uploading to Files section.
YAHOO! GROUPS LINKS
- Visit your group "AccessDevelopers" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.