Hide a column on datasheet subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there!

I need to hide a column in a subform that is in datasheet format if there is
no data in the column that is if there is nothing greater than 0. I have
tried both of these:
Me.ControlName.Visible = False
Me.Controls(8).Visible = False

but neither one works. I know this will work in a continuous form to hide
text boxes but it doesn't work here. Is there some sort of column property
that I can access?

Thanks for all your help!
 
In Datasheet View, this command:

DoCmd.RunCommand acCmdHideColumns

will hide the column that has the focus.

Barry
 
Back
Top