"Click to add" column in Access 2010

[Tammy]

Hi,
In Access 2007 you are able to right-click on the "Click to add" column in
Datasheet view of a table and hide it so that it's removed from view. Cannot
find where I can do that in Access 2010... Are we stuck with that annoying
extra column remaining in the view? My users will be using a form to enter
data, so it's not that big of an issue, but I'd like to hide it if possible.

If anyone knows a way to hide/remove it, please pass the info along.
Thanks!!

 

[Jeff Boyce]

Tammy

If I recall correctly, that only shows when you/your users are working
directly in the tables.

In Access, tables store data, while Forms display data. I'd stick with the
forms...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Tammy]

Hi Jeff,

Sorry - didn't get notified of your response.

Yes, it does only show in the tables, and we would only use a form for
displaying and entering data. I was just wondering if you could hide that
column in 2010, as in 2007. No biggie, we'll just ignore it now.

Thanks!

 

[Disappointed]

Very disappointed by Jeff Boyce's answer. It's up to the user how they use an app.

Tammy, don't feel as though you should apologise to such an arrogant fool.

File - Options - Current Database and uncheck Enable design changes in Datasheet view. Close and re-open the db and it's gone.

Nick
Not an MVP

 

[jimtim]

Nick,
Thank you for your response to Tammy! This is my first post here, it came up top in Google when I was looking for an answer to this annoying quirk.

I saw Jeff's response and thought 'how preachy and arrogant', and he didn't even answer the question.
Thanks for covering it,
--Jim

 

[maxamillion]

Nick
Thank you for answering Tammy's question

Like Jim, I find this quirk annoying and someone has taken the time to answer the question.

Another method is
run this code
CurrentDb.Properties("AllowDatasheetSchema") = False
You will still need close and open though.

 

[dallin]

(old post I know, but relevant)

Thank you Nick. Not only for standing up and saying something but also for answering my own question - I was trying to turn it off and didn't realise I needed to reboot the database.

 

[philhaney]

Hi Tammy,

I recently made the jump from Access 2003 to Access 2013. However, most of the time when I search the internet for help on 2013, I get help for 2010, so this may apply to you. If it doesn't, please forgive me.

To hide that pesky column [in Access 2013], right click on the heading of any column in Datasheet View and select "Unhide Fields" (this is not intuitive). Then uncheck the box next to "Click to Add." Click "Close" and you're done...

-Phil

"Quini, quidi, quici" - I came, I saw, I played a little quidditch.

Hi,
In Access 2007 you are able to right-click on the "Click to add" column in
Datasheet view of a table and hide it so that it's removed from view. Cannot
find where I can do that in Access 2010... Are we stuck with that annoying
extra column remaining in the view? My users will be using a form to enter
data, so it's not that big of an issue, but I'd like to hide it if possible.

If anyone knows a way to hide/remove it, please pass the info along.
Thanks!!