Thanks for following up. Unfortunately, I am not hiding the values for security reasons. I am hiding them to simplify the view for the user.
--- In AccessDevelopers@yahoogroups.com, "Duane Hennessy" <[EMAIL PROTECTED]> wrote: > > Well, let's start by keeping it simple! How about setting the field value to a password field instead? It wouldn't hide it but would sure make it hard to read. :) > > 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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
