Page setup: page size change form A4 to Letter

  • Thread starter Thread starter Bruno Holvoet
  • Start date Start date
B

Bruno Holvoet

Hello,

I have a programm, with reports made for A4 page size.
Now for some reports, not all, the page size is changing from A4 to letter.
I changed it many times.. but still....letter.....
?? (the mdb is regularly copied)
 
Couple of possibilities:

1. It could be this problem, caused by Name AutoCorrect.
Lost Printer Settings When Name AutoCorrect Is Enabled
at:
http://support.microsoft.com/?id=240826
You *really* want to get rid of this disaster of a feature anyway. More
info:
http://allenbrowne.com/bug-03.html

2. If that's not the issue, open the problem report in design view.
Choose Page Setup from the File menu.
On the Page tab, how is the Paper Size set?
Does it make a difference if you set Default Printer verses Specific
Printer?
 
Thank for the tips,

I have tried the Name Auto-Correct options
without success.
I have tried other printer settings.. without success

Perhaps this information helps:
former it was a 2K version, now 2K3
A new report in this database has no problems

Is there a possibility to remove all the printerinfomration, in a report,
with code?
 
Allen,

I did it,

I recovered the good printersettings from one report, and i overwrite the
bad ones like this;

'Good report
DoCmd.OpenReport "Report2", acViewDesign
Set RS = Application.Reports("Report2")

'Bad report

DoCmd.OpenReport "rpt_INDEX_1_2005_01_21", acViewDesign
Set RT = Application.Reports("rpt_INDEX_1_2005_01_21")
'This did it
RT.PrtDevMode = RS.PrtDevMode

DoCmd.Close acReport, "rpt_INDEX_1_2005_01_21", acSaveYes


Thanks
 
Back
Top