View whole form

  • Thread starter Thread starter JB
  • Start date Start date
J

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
 
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
 
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
 
JB said:
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
Click to expand...

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.
 
thanx :)

Rick Brandt said:
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.
Click to expand...
 
Back
Top