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

ms-access ms-access-2010
EJ Mak picture EJ Mak · Sep 3, 2014 · Viewed 11k times · Source

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?

Answer

Fionnuala picture Fionnuala · Sep 8, 2014

Like so:

Set options to avoid design changes

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

Related questions

How to insert values into the database table using VBA in MS access

I've started to use access recently. I am trying to insert a few rows into the database; however, I am stuck as it is throwing an error: Too few parameters. I have a table test with only one column in …

Read More
Corrupted Access .accdb file: "Unrecognized Database Format"

I'm having a problem. One of my databases on our shared network will not open for any user. It says "Unrecognized Database Format." I've had this problem before but was still able to open the database, compact and repair, or …

Read More
Access 2010 VBA query a table and iterate through results

I have a query that I want to execute against a table. With the results I want to do something. In my head the pseudo code is: var q = "select * from table where some condition"; var results = db.getResults(q); …

Read More