Can I hide the 'Click to Add' column in Access?

Question

When viewing a Microsoft Access table in Datasheet View, the right-most column is titled 'Click to Add,' allowing someone to add a new column without using the Design View. Is it possible to hide this column?

Trenton

Look at Options, the cure is available there. – Siding

I didn't see the option. Where exactly? – Trenton

Answer 1

Like so:

Do not forget that you must close and open the database for the change to work.

Siding

Answer 2

You could also right-click any column header in the table, select 'Unhide Fields' and then uncheck 'Click to Add' at the bottom of the list.

Khamsin

This is a clever idea how to hide Click to Add on table level instead of database level. – Schematize