I Ian Godfrey Sep 8, 2003 #1 When I "print" from form view every record in the table prints. How do you print just the "on-screen" record? Thank you.
When I "print" from form view every record in the table prints. How do you print just the "on-screen" record? Thank you.
J Joan Wild Sep 8, 2003 #2 You should create a report for printing the information. Forms really aren't meant for printing. Once you have the report done, you can add a button to your form with the following in its onclick event: DoCmd.OpenReport "ReportName", acViewPreview, , "SomeID= " & Me!SomeID Substitute the name of your report for ReportName. SomeID refers to the unique identifier for the record on your form
You should create a report for printing the information. Forms really aren't meant for printing. Once you have the report done, you can add a button to your form with the following in its onclick event: DoCmd.OpenReport "ReportName", acViewPreview, , "SomeID= " & Me!SomeID Substitute the name of your report for ReportName. SomeID refers to the unique identifier for the record on your form
D DBaxter Sep 8, 2003 #3 If you are like me, I like to print the form to show the info as it is entered. Go to design view, on the "toolbox" menu bar, click on the "page break" icon and click on the bottom of your form, just above the Form Footer bar.
If you are like me, I like to print the form to show the info as it is entered. Go to design view, on the "toolbox" menu bar, click on the "page break" icon and click on the bottom of your form, just above the Form Footer bar.
