MS Access Printing Problem

[artmoffa]

I want to distribute an application that has several reports but if the user has a different printer than the one specified when I designed the reports, the page layout changes.

Is there a standard way to create a report that will print the same despite the printer used?

 

[Guest_imported]

Your printer should not matter. Access sends all print information to windows default printer print queue. The print drivers then work out how to print the document. I suspect that your problem may lie in the Access 2000 bug. This causes reports to reset to default settings. For example if you designed a report in Landscape access sometimes resets the value to portrait. To prevent this get the SR1 update or disable perform auto name correction in tools/options/general.

hth

Chucky

 

[kenman]

I have been struggling with this 'reset' to default settings problem...until I bumped into your solution. How did you find this, as the checkbox under tools/options/general is not real intuitive. How can I find a list of other fixes available in SR1? Is SR1 the same as SR1a?
thanks,
Ken