How do I format a form for printed or online use?

T

T.Jackson

I'm attempting to create a form for both online use and to be printed. I
want you to be able to key on the form without effecting the format.
 
S

Sprinks

Hi, T.

Access doesn't provide much flexibility in printing a form. You have much
more control and flexibility by duplicating the form's format in a report.
Then you can provide a command button to preview the report.

To filter the report, for only the current record, place the following
criteria in the query underlying the report in the primary key field:

=Forms!MyForm!MyPrimaryKeyFieldName

Substitute the name of your form and form control in the above expression,
such as:

=Forms!Orders!txtOrderNumber

Hope that helps.
Sprinks
 
Top