Access - extra blank row at the end of table

Access adds an extra blank row in a table, and this is counted as one of the records, but it is really not. This can be confusing when I run queries, etc, on this table, as it appears that the output result is one record off, but it is not and is due to the blank row.

I am also unable to delete this blank row from the table.

Suggestions are appreciated.
exp vgAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ste5anSenior DeveloperCommented:
Access does add blank rows. The data grid shows one for tables where you can add a row. This blank row in the grid is not counted.

Please post an example database showing your behavior.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
exp vgAuthor Commented:
Thank you
Jeffrey CoachmanMIS LiasonCommented:
There is normally "what appears to be" a blank record an the bottom of most datasheet views.
This is not considered in any "Counts" by/in Access.

You can hide this, by setting the "Allow Additions" property of the form to No.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
It's a *non-issue* .... it's the New Record Row.  It does nothing and is not counted in any record count.

You have no worries ...

mx
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
"Access does add blank rows."
It's not really a 'blank' row ... implying a row with no or Null data.  It;s just the position to add a new record.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.