Form and SubForm

[an]

When we open a continuous form or subform, the last record
is "blank" without data.
Is possible to hide it, please?
Thanks in advance.
an

 

[Allen Browne]

The blank row is there to add a new record.

If you do not want it, open your form in design view, and in the Properties
box, set AllowAdditions to No.

Be aware that if there are no records to show (e.g. if the form is
filtered), the detail section will go completely blank.

 

[an]

Ok. Exactly.

Many thanks.
an

-----Original Message-----
The blank row is there to add a new record.

If you do not want it, open your form in design view, and in the Properties
box, set AllowAdditions to No.

Be aware that if there are no records to show (e.g. if the form is
filtered), the detail section will go completely blank.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.




.