Suppress line in MS Access datasheet

I have a datasheet where I'm adding new rows but as soon as I start changing a column a second row appears with a star below with similar values. Why does this row appear and is there a way to hide it or at least that it show null values?
Picture0001.jpg
mpimAsked:
Who is Participating?
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 grids of updatable data sources show always this line with asterisk as placeholder for a new line. The values you see are the default values of the tables or the controls.

In short: This is the default behaviour, by design and as a user I don't expect it to be different.
0
Dale FyeCommented:
I personally prefer to have a popup form for data entry, and generally only use datasheets for data display/edits.
0
Jeffrey CoachmanMIS LiasonCommented:
Why does this row appear and is there a way to hide it or at least that it show null values?
In your case, you have quite a few currency fields, ...anytime you create a number or Currency field, the default value will automatically be set to zero.
You can turn this off by explicitly opening the table in design view, and deleting any default values for the currency fields.

(However for you "Curr"...? field, ...since this is text, ...you may need to keep the default value)

JeffCoachman
0

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
Jeffrey CoachmanMIS LiasonCommented:
Thanks

But also heed the advice of the experts above.


Jeff
0
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.