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.
 

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

Similar Threads

Select to reference an other record or row 1
Comparison of columns using Conditional Formatting 3
using Gridview xpath to get xml node 3
Writing record from Access to multiple excel spreadheets 1
Removing empty cells from spreadsheet data 1
Create Excel Spreadsheet from Access with 1 to many relationship 2
Copy paste from one worksheet to other. 2
Sql or a better way 3

Top