Empty fields and records hidden in Datasheet view, need to unhide

Question

I feel like this is probably a super-basic question, and while I took a class in Access and remember a lot, now that I'm trying to use it, I realize that I completely forgot how to do some of the very basic things.  All the questions I try to research on this are way far beyond level of complexity of what I'm trying to figure out.

I'm trying to enter data into the datasheet view on Access. I started a table, and when I did, it wasn't like this.  Somewhere along the line of trying to remember how to do queries and things like that, I must have clicked something, so that, now, in datasheet view, all the empty fields and records that I have not gotten to fill out yet, are hidden.   I can still maneuver, but there are some aspects of this hidden setting that makes adding new fields to the datasheet a major headache.

I can still add new fields, particularly in design view.  It's allowing me to still function, but I need to know what it was that I accidentally clicked to make all the empty cells hidden like this so I can undo it.

I even tried to open up a brand new database in Access to see if all the empty cells are visible in a brand new datasheet, but they are not visible there either.  I must have changed a default setting somewhere, but I can't figure out what I did, or how to undo it.

Please help.  This is frustrating, and even more frustrating that I cannot find an already answered question on this topic.

Answer 1

Hi. Just to make sure we're on the same page, can you post some screenshots? Thanks.

Answer 2

Right click on any column in Datasheet view and select Unhide. It should give you a list fields in the Recordsource with check boxes to hid or unhide.

However, you shouldn't be working directly in tables. Any interaction with the data tables should be done through forms.

Answer 3

I'm not sure if this is your problem but take these steps:

1. open the table in datasheet view
2. Make sure you are under the Home tab on the Ribbon.
3. In the Records Group click on the More icon. You will see this list. Click on Unhide Fields.