how to hide the last blank record in form

G

ghost

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?
 
J

John W. Vinson

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]
 
B

Brendan Reynolds

ghost said:
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).
 

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

Top