Text box validation

[Kissi Asiedu]

I have a two part question;
1. I have text boxes on a form and I don't want user to move to the next
field without entering any data.
2. I have 10 records on a report and I want each record to be printed on
each page. So I will have 10 pages when printed.
Any suggestions to accomplish these tasks will be very much appreciated.
Thanks.

[Larry Linson]

"Kissi Asiedu" <ki*******@aol.com> wrote

I have a two part question;
1. I have text boxes on a form and I don't want
user to move to the next field without entering
any data.
Just for the record, those things you see displayed on Forms are "Controls",
not "Fields". Fields exist in Tables and Queries and _contain_ data values;
Controls exist in Forms and Reports and _show_ data.

It will take some work to control movement from one Control to another,
because that isn't the way Access is intended to work. One way to do that is
to start with only the first Text Box you intend to allow the user to use
"enabled" and to enable the next one in sequence in the AfterUpdate event of
the first. Of course, you probably ought to re-disable all following Text
Boxes if the user clicks back into one where data has already been entered.

If you have all the Text Boxes enabled at the beginning, the user could just
click into the last one in the sequence, so you'd have to do a great deal of
testing in the GotFocus event.
2. I have 10 records on a report and I want each
record to be printed on each page. So I will have
10 pages when printed.
In design view of the Report, take a look at the Force New Page property of
the Detail Section of the Report.
Any suggestions to accomplish these tasks
will be very much appreciated. Thanks.

You are welcome.

Larry Linson
Microsoft Access MVP