This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a couple of fields that are in my design view of my table in Access but they don't show up in my DataSheet view. I am very new to Access and probably have made some silly change along the way. Any suggestions?
A family of Microsoft relational database management systems designed for ease of use.
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.
Answer accepted by question author
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 62%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
I expect the columns/fields are for some reason hidden. I would try to click-hold-drag across all column headings then right-click and select "Unhide Fields". If this doesn't bring them back then do the same and set the Field Width to 20.
Thanks. That is what it was. I figured that was the case but couldn't figure out how to unhide in access. I appreciate the help!
Sorry in answer to all three of your questions:,
I am not sure what you mean by linked. It doesn't tie in to any other tables if that is what you are asking. There are Queries built off of it, but it does not populate in anyway based on any other table. Only the form I use to input data to it. The form was built when those fields showed up and has a spot to enter data to those fields.
I am definitely looking at the table not a query. It is the first item in my Access Objects under tables.
The headings and the Data are both missing in Datasheet view.
When I do a query it will show the columns I am looking for.
In my backups way back if I bring them up, the columns (headings and data) did show up.
Hope this is enough to go on, I apologize as I say I am new to Access
So when I open Access I have tables/queries/forms on the left hand side ledger.
When I Click on my table, I am missing 3 columns/fields that used to be there. They were populating via a form I use for my data entry. When I click on Design view they are still showing up in the list of fields I should have but when I go back to data sheet view they are not there.
Is the table linked?
Are the field column widths set to very narrow?
Are you for sure looking at the table's datasheet and not a query?