Hello,
The title of this post should of been:
Can't set size of an Access report so that it prints without printer error!
Sorry about that!
THE PROBLEM:
I have Windows 10 with Access 2007 installed on my machine.
I am trying to print a report from Access to my printer but my printer complains on the size not being correct??
The printer I'm printing on is the default one which is set to 8.5" x 11".
In ACCESS:
My width of my report is 22.751cm (8.9”). My report's page set up is: Com10 Env. (4.125" x 9.5") landscape.
The VBA command that prints the report is:
DoCmd.OpenReport "rpt_TimeSheet", acViewNormal
When The above VBA access command is executed, the printer signifies an error by illuminating a red light and
I need to walk to the printer and force it by selecting the 8.5" x 11" paper size so that the report prints out.
Therefore the report prints fine but I have to instruct the printer every time I print this report!
Does anyone know what I am doing wrong ?
All help is very much so appreciated
Bob