Possible to remove the first record or last empty

[Thinh]

When i create a table from scratch there is always a record and also when i run a query on the table there is always an empty record at the last line. Is there anyway to i cant get rid of it or hide it. it can be confusing and the user might add line that not suppose to be there.

thanks in advance

 

[Thinh]

I know is there is way to get rid of the last record in query or list

when i use a query its shows an empty records aswell which is confusing for user. its okey if the list contain many records but when it only contain a few record it can look confusing

 

[Moniker]

That may be a time to do it through a form like Pat suggested. That way, you have complete control over how it is displayed. You never want your users accessing the tables directly as they may or may not (usually the latter) know what changing a specific field will do in other parts of the DB.

However, Access has been using a very similar interface since Access 2.0 (around 1994), so if you're users are still this unexperienced after 17 years (unless they are under 17), that's a little strange. Even the biggest of the bigwigs where I work (a huge company) know how to use Outlook, Word, and some Excel and Powerpoint. The Access applications we provide all have very specific forms designed to look not like a database, as many people still don't see the difference between say Access and Excel (much less RAM and a hard drive).