Switching between two columns in a form viewed as datasheet

[S. van Beek]

Dear reader,

I try to switch between to columns in a form showing as datasheet view.

The idée is to show one of the two columns in a datasheet.

The problem is that the property visible yes and visible now dos not work in
the data sheet view.

Is there any one woo can help me with the right code in VBA to realize this
visible yes/no column in a form presented as data sheet view.

Thanks for any help,

Simon van Beek

[David Lloyd]

Simon:

You can use the ColumnHidden property to toggle the visibility of columns in
Datasheet view. For example:

Forms!MyMainForm!MySubform.Form!MyTextBox.ColumnHi dden = True

The following KB article may also be a useful reference.

http://support.microsoft.com/default...b;en-us;210427
--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
"S. van Beek" <S.******@HCCnet.nl> wrote in message
news:43*********************@textreader.nntp.hccne t.nl...
Dear reader,

I try to switch between to columns in a form showing as datasheet view.

The idée is to show one of the two columns in a datasheet.

The problem is that the property visible yes and visible now dos not work in
the data sheet view.

Is there any one woo can help me with the right code in VBA to realize this
visible yes/no column in a form presented as data sheet view.

Thanks for any help,

Simon van Beek