Hiding/Unhiding Named Columns in Datasheet (Access 2007)

[LA Lawyer]

I want to unhide/hide columns named "Full Name" and "Address" on a datasheet
which is on a subform. How is that done?

 

[Jeff Boyce]

I suppose one way might be to set the column's width to 0 to hide it...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[LA Lawyer]

Yes, but how do I reference the column?

I suppose one way might be to set the column's width to 0 to hide it...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Banana]

The same way you would reference a regular old field (or was it control?)

There are few hidden properties that are datasheet-only such as
ColumnHidden, ColumnFreeze and maybe ColumnWidth.

Take a look:
http://msdn.microsoft.com/en-us/library/aa217449(office.11).aspx