View whole form

[JB]

Hello
I've created a form so that the whole form can be seen without having to
scroll down or up. Trouble is when going to 'page preview' to print, it
shows 2 records.
If I spread out the fields and rows, then I will have to keep scrolling when
editing and entering data.
Is there a way in form view (like in Word and Excel) that you can zoom out.
And if not, why not?
Thanks
J

 

[Larry Linson]

I'd suggest you create a similar-appearing Report and print that instea of
printing the Form, as it seems you are doing. You have much more/better
control over printing in Reports.

Larry Linson
Microsoft Access MVP

 

[JB]

Thanks for your reply
I did that in the first place but when you open the report you can only
scroll to the next records. And if there are hundreds how do you print one
particular one? There's no 'find' option or anything
J

 

[Rick Brandt]

Thanks for your reply
I did that in the first place but when you open the report you can
only scroll to the next records. And if there are hundreds how do you
print one particular one? There's no 'find' option or anything
J

You open the report with a filter applied so that it only contains the one
record you want to print.

DoCmd.OpenReport "ReportName",,,"Filter Criteria Goes Here"

See help file topic for the OpenReport method for more details.

 

[JB]

thanx

You open the report with a filter applied so that it only contains the one
record you want to print.

DoCmd.OpenReport "ReportName",,,"Filter Criteria Goes Here"

See help file topic for the OpenReport method for more details.