Hide a Column

  • Thread starter Thread starter James
  • Start date Start date
*table* columns? i don't think so. but i can't think why you'd need to
anyway; adding/editing/deleting records should be done via a *form*, not
directly in a table. in a form whose DefaultView property is set to
Datasheet, you can set a control's ColumnHidden property to True, as

Me!ControlName.ColumnHidden = True

read up on the property and other related properties in VBA Help, so you'll
understand how best to use them.

hth
 
and btw, in Access, macros and VBA are two different things, though they're
used for the same purpose - to manipulate the data and objects in a
database. VBA is much more powerful and flexible than macros.

hth
 
Back
Top