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?

Look at Options, the cure is available there. – Fionnuala Sep 03 '14 at 18:21 — Fionnuala, Sep 03 '14 at 18:21
I didn't see the option. Where exactly? – EJ Mak Sep 06 '14 at 23:07 — EJ Mak, Sep 06 '14 at 23:07

score 24 · Accepted Answer · answered Sep 08 '14 at 01:32

24

Like so:

Set options to avoid design changes

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

answered Sep 08 '14 at 01:32

Fionnuala

90,370
7
114
152

score 5 · Answer 2 · answered May 30 '18 at 17:06

5

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.

answered May 30 '18 at 17:06

rheffer

51
1
2

1

This is a clever idea how to hide *Click to Add* on table level instead of database level. – miroxlav Sep 18 '18 at 16:50

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

2 Answers2