SR 1/1a not working completely - Keeps page settings & loses page size

[Skolastix]

Hi,

I have just installed the SR 1/1a on two computers and it works well except that the page size still converts back to letter instead of legal format when set from computer # 1 and viewed from computer # 2 (in a networked system). The margins and the orientation are correct. I have also disabled the Name Auto correct on both systems just to ensure that there are no errors. If anyone knows how to use VBA to set the page size to Letter or Landscape that would be very appreciated (an easier fix would be better). Thanks. X-)

 

[DougP]

I know I hate that.
This MAY work

Create a new printer which is the same as the other one except its default paper size is leagal. So you have 2 printers in your printers folder. As you know this is done in the Printers folder outside of Access

Then set this report to use that new printer.
This happens everytime you view the report and cancel it, instead of print it.

Se my FAQ
faq181-14 How do I make a report Print to the same Printer everytime regardless?
DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive