Continous form: How to remove "blank" record

J

jamiedora

Hello,

I would like to ask if it is possible to remove the blank record at the
end of a continous form. I.e.using the example below:

1 Data1-1 Data2-1 Data3-1
2 Data1-1 Data2-1 Data3-1
3 Data1-1 Data2-1 Data3-1
(auto-number)

As can be seen this last record has a null value for the ID field and
is displayed on the contious form. Is there an visual basic code or
access option to remove this.

Thanks,

Jamie
 
A

Allen Browne

You can set the form's AllowAdditions property to No if you don't want the
user to be able to add records.

Be aware that the Detail section of the form will then go completely blank
if there are no records to show.
 
Top