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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tony Williams - 18 Nov 2007 13:39 GMT

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

Reply to this Message

Al Campagna - 18 Nov 2007 14:41 GMT

Tony,
Right click on the control in Datasheet View, and select Hide Column.

Signature

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

>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

Reply to this Message

Tony Williams - 18 Nov 2007 14:52 GMT

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

> Tony,
> Right click on the control in Datasheet View, and select Hide Column.
[quoted text clipped - 3 lines]
> > control and I don't want it to be seen.Thanks
> > Tony

Reply to this Message

Douglas J. Steele - 18 Nov 2007 15:47 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Tony,
> Right click on the control in Datasheet View, and select Hide Column.
[quoted text clipped - 3 lines]
>> control and I don't want it to be seen.Thanks
>> Tony

Reply to this Message