Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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?

like image 599
EJ Mak Avatar asked Sep 03 '14 18:09

EJ Mak


2 Answers

Like so:

Set options to avoid design changes

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

like image 98
Fionnuala Avatar answered Oct 13 '22 19:10

Fionnuala


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.

like image 21
rheffer Avatar answered Oct 13 '22 19:10

rheffer