Hide a Column

T

tina

*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
 
T

tina

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Consolidation Table from Different Excel Tabs with Different Format 1
Insert Index into a Table 1
Hide Row Numbers/Column Letter in VBA 1
Hide columns based on row values 2
Create form with checkbox les that expand and collapse sections of the form? 0
Inserting a column to the Gantt view 0
Format column widths from one table to a separate table on same page 1
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0

Top