I have a form linked to a table that has a few thousand records. A few minutes ago I figured out how to print just the record that I'm on (in form view) - using the "PrintOut" command.
The problem is - the "PrintOut" command doesn't seem to be taking my page setup options for this form. I want to print on Legal - (which shows up in the page setup when in the form). But when I use the PrintOut command - it prints on letter.
Again - I want the print out to be the actual GUI-looking form with the data filled in for the record I'm on. Docmd.PrintOut seems to be working (if I use the "(acSelection)" option). But it won't let me set the page layout (especially paper size)
Any help would be appreciated.
The problem is - the "PrintOut" command doesn't seem to be taking my page setup options for this form. I want to print on Legal - (which shows up in the page setup when in the form). But when I use the PrintOut command - it prints on letter.
Again - I want the print out to be the actual GUI-looking form with the data filled in for the record I'm on. Docmd.PrintOut seems to be working (if I use the "(acSelection)" option). But it won't let me set the page layout (especially paper size)
Any help would be appreciated.