11
votes

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?

2
Look at Options, the cure is available there. - Fionnuala
I didn't see the option. Where exactly? - EJ Mak

2 Answers

24
votes

Like so:

Set options to avoid design changes

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

5
votes

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.