Hiding a column on a form in DS view

[tsison7]

I want to call up a form in DS view with the option of hiding data via an
option group. I set me![controlname].visible = false depending on the option
called and the control disappears in Form view but not in DS view. Any help
is appreciated.

 

[Linq Adams via AccessMonster.com]

In Datasheet View you really can't do much in the way of formatting things
such as visibility using the Properties Box. To make a column disappear in a
Datasheet View, you need to use the ColumnHidden Property:

Private Sub Form_Load()
Me.YourControlName.ColumnHidden = -1
End Sub

To make it visible again you'd use

Me.YourControlName.ColumnHidden = 0

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com