allow additions, but not show new record?

[Josh]

I've had people get confused about the "new record" line at the bottom of
datasheet or continuous forms (for example, "why's this thing showing 4 records
when I know there's only 3")....

Is there any way to not show the "new record" line until you actuall start a new
record? Of course, would have to use a command button, or the new record button
on the navigation buttons..

btw, there is at least one field which has a Default value, if that matters.

Thanks, Josh

 

[tina]

well, you could just turn off the navigation buttons, which would also
eliminate the recordcount box; i'd think a "blank" line at the bottom of the
existing records would be self-evident as a new record, and the user can use
the arrow keys and Ctrl+Home and Ctrl+End keys to navigate the "list" of
existing records.

as another alternative, you could set the form's AllowAdditions property to
No. then use a command button (or perhaps a toolbar button on a form in
Datasheet view) to first set the AllowAdditions property to Yes, then move
to a new record. getting the form *back* to not allowing additions might be
a little tricky; you could try adding code to the form's AfterUpdate event,
as

If Me.AllowAdditions Then Me.AllowAdditions = False

hth

 

[Josh]

I tried turning off the navigation buttons, and record selectors, but new blank
line still shows at the bottom. Yes, I'd think it would be self-evident also,
but it seems some people (users) don't think so.

I'll try to experiment with the AllowAdditions property. This isn't a critical
thing, so not a big deal.

Thanks