Duane.
--- In AccessDevelopers@yahoogroups.com, "Chad Lisowe" <[EMAIL PROTECTED]> wrote:
>
> 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
- 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.
