Why can't I make a control invisible in Datasheet view?

[Guest]

I have a subform that is a datasheet. I want one of the controls not to be
visible. I've change the Visible property to No but it still shows in the
subform. How do I make it invisible. It is used as part of a calculated
control and I don't want it to be seen.Thanks
Tony

 

[Al Campagna]

Tony,
Right click on the control in Datasheet View, and select Hide Column.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Guest]

Thanks Al I didn't realise it was that easy!
Cheers
Tony

 

[Douglas J. Steele]

To do it programmatically, you set the field's ColumnHidden property to True
(as opposed to setting its Visible property to False).

If you're using datasheet views, the following is an invaluable reference
http://msdn2.microsoft.com/en-us/library/aa217449(office.11).aspx