Report margins change between computers

[RichO]

I design/maintain an Access database for a friend's business using my home computer. The printer he uses allows for much smaller margins than mine does, so anytime I edit a specific report that uses very small margins, my computer automatically increases them to the minimum margins my printer allows and when the business owner runs the report on his computer it spills on to extra pages.

Right now every time I make a change, I need to go directly to his computer and adjust the margins within the report after the new front end is uploaded.

Is there any way around this, such as telling Access to ignore the printer's minimum margins?

Thanks

 

[apr pillai]

Take a look at the following links:

1. Network and Report Page Setup
2. Network and Report Page Setup-2
3. Network and Report Page Setup-3

 

[gemma-the-husky]

you could probably install his printer driver on your system, then set that as the default printer when you use access for him.

but of a pain to keep changing it back and forth, but it might help

 

[RichO]

you could probably install his printer driver on your system

I just tried to do that and the driver install stalled because the actual printer needs to be connected to my computer to proceed.

I will look into the changing the margins through VBA though and see if I have success with that.

Thanks for the help