Share via

Access Inventory Table missing add field button

Anonymous
2019-11-21T21:56:01+00:00

The add new field button is not available in the Access inventory template table (inventory sheet)... even in datasheet view. I can't find any way to get it to show up. It is present when I go to create a new database from scratch or in other templates,

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
2019-11-21T22:30:10+00:00

These are the tables I see in that template. I can right click, choose Design, and add fields. This is the preferred way because you can set all properties.

If you REALLY want the "Click to Add" option as the last column in datasheet view, make sure File > Options > Current Database > "Enable design changes for tables in Datasheet view" is checked.

Was this answer helpful?

1 person found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ScottGem 68,830 Reputation points Volunteer Moderator
    2019-11-21T22:25:13+00:00

    Right click on the table in the Nav Pane and select Design mode.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2019-11-23T08:14:17+00:00

    Hi Millpoint63,

    Did you check above replies? If you still need help, please update us when you have time.

    Regards,

    Neha

    Was this answer helpful?

    0 comments