Hide a column on datasheet subform

[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!

 

[Guest]

In Datasheet View, this command:

DoCmd.RunCommand acCmdHideColumns

will hide the column that has the focus.

Barry