Please help w/eliminating blank row on forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you make the last blank row go away in a form? Why is there a blank
row? Any help will be greatly appreciated. Thank you.
 
How do you make the last blank row go away in a form? Why is there a blank
row? Any help will be greatly appreciated. Thank you.
Click to expand...

There's a blank row because - usually - users want to be able to add
new records to a table, rather than just editing existing records. The
blank record is the "new record" into which that information can be
typed.

If you wish to prevent them from doing so, set the Form's Allow
Additions property to No.

John W. Vinson[MVP]
 
If I set the Additions property to No, will this also prevent the user from
updating certain fields? or does this just pertain to adding rows?
 
Edits will still be allowed. Their status is controlled by the AllowEdits
property.

Sprinks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Match two columns/rows within multiple sheets then paste answer... 0
Unremovable horizontal scroll bar on subform 1
Hidden text in tables causes empty rows 0
VBA to automatically cut, paste entire row based on date input and delete row 0
How To Have A Form Start With A Blank? 3
Need help with an excel macro to group & outine rows 0
Eliminate blanks while copy row and transpose 11
Filter tabular form by combo box 0

Back
Top