hide colums in datasheet view via code

  • Thread starter Russ via AccessMonster.com
  • Start date
R

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
 
F

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
Click to expand...

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.
 
Top