how to hide the last blank record in form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ghost - 17 Jan 2008 18:04 GMT

Greeting,
I have a Continuous form that shows all records in a table. as you know
there is a blank record appears in last of the table. I would like to hide
this record from showing in the Continuous form. How can I do that?

Reply to this Message

John W. Vinson - 17 Jan 2008 18:58 GMT

>Greeting,
>I have a Continuous form that shows all records in a table. as you know
>there is a blank record appears in last of the table. I would like to hide
>this record from showing in the Continuous form. How can I do that?

It's not really a record - it's just a space into which the user can insert a
new record. If you don't want users to add new records to the table at all,
simply set the Allow Additions property of the form to No. If you want them to
be able to add new records but not see the blank line, you'll need to make
some other provision to let them do so - pop up a new single form, temporarily
change the Allow Additions property, or whatever fits your needs.

John W. Vinson [MVP]

Reply to this Message

Brendan Reynolds - 17 Jan 2008 19:02 GMT

> Greeting,
> I have a Continuous form that shows all records in a table. as you know
> there is a blank record appears in last of the table. I would like to hide
> this record from showing in the Continuous form. How can I do that?

Set the Allow Additions property to No. (False if setting it in code).

Signature

Brendan Reynolds

Reply to this Message