hide colums in datasheet view via code

[Russ via AccessMonster.com]

Does anyone know of a way to hide colums in datasheet view via code, I have a
couple of hidden fields on the form but when they view it in datasheet view
they show back up so I want to hide them.
Any ideas would be great!
Thanks
Russ

 

[RobFMS]

Have you considered making a query from the recordsource and exclude the
columns you want to hide?

--
Rob Mastrostefano

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

 

[fredg]

Does anyone know of a way to hide colums in datasheet view via code, I have a
couple of hidden fields on the form but when they view it in datasheet view
they show back up so I want to hide them.
Any ideas would be great!
Thanks
Russ

Code the form's load event:

Me!ControlName.ColumnHidden = True

Change ControlName to whatever the actual name is of the control.

However, the user can still view the column if they click on
Format + Unhide column, so you might want to remove that option from
the Format menu.