Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 209148 - Last Review: June 28, 2004 - Revision: 2.0
ACC2000: Cannot Save a Blank Record in a Table or Form
This article was previously published under Q209148
Novice: Requires knowledge of the user interface on single-user computers.
You cannot save a blank, new record in a table or form.
Microsoft Access requires some form of data entry in the new record in
order to create it.
To add a blank record to a table, press the SPACEBAR in any field in the
table.
To add a blank record to a form, press the SPACEBAR in any field whose
ControlSource property points to a field in the underlying record source. A
SetValue or SendKeys macro action directed at the bound control will also
add a blank record to a form.
When you are adding new records, Access does not recognize that a
new record is being created until a field in the record has been "dirtied,"
or has received some input from an external source. That external source
can be a keyboard entry (other than the TAB or ENTER keys), or it can be
the result of a SendKeys or SetValue macro action. Note that default values
for fields do not qualify as external input, and have no effect on
triggering a new record in a table or form.
Steps to Reproduce Behavior
- Change the ProductName field's AllowZeroLength property from No to Yes.
- Save the table and then switch to Datasheet view.
- On the Records menu, click Data Entry. Note that the insertion point is positioned at the first field in a blank record.
- Press the TAB key to move through all the fields. Note that the record indicator does not increment, indicating that you are still on the same record and that the record has not been saved.
- Press the TAB key to move to the ProductName field, and then press SPACEBAR.
- Press the TAB key to move through the remaining fields until you return to the ProductName field. Note that the record indicator is increased by one.
For more information about adding records, click
Microsoft Access Help on the
Help menu, type
adding records to tables in the Office Assistant or the Answer Wizard, and then click
Search to view the topic.
APPLIES TO
- Microsoft Access 2000 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate