Page size for printing a form Access 2007

[Malcolmneill]

Can someone help me solve a problem.

For various reasons I need to print form(s) in an application and this all works. However, a new printer kept giving a paper size error on 1 form. After some investigation I discovered that this form was sizing to letter not A4, all the other forms that I print size to A4. Now as far as I can see there's no difference in any settings and they are all running using the same set of access options etc.

So why is 1 form deciding to adopt a letter size? Is there some hidden parameter to set the page size or is it purely down to the form width? Obviously I have a temporary fix, set the printer to "fit to A4", but why would this happen?
Thanks for any input
Malcolm

 

[AccessMSSQL]

Did you recently make changes to the form in question and are you printing to different printers? If so that particular form may have saved the printer settings from a different printer. Also, check the form in question width and height properties and compare it to your other forms. It may be slightly different size.

I generally stay away from allowing users to print forms - if they need to print I create a separate report for this.

Just some thoughts.

 

[Malcolmneill]

Hi, thanks for quick response. No, no changes to from and yes it's a new printer that shopwed up the problem. I suspect it's always been that way, just that the old printer was probably set to "Fit" and no one noticed, including me.

Yes I have checked the size compared to others and it is different. I will see what happens if I adjust it, but that's a bit difficult because of the data on the form.

FYI, the reason I use a form is because there's some sophisticated programming in the background which also updates tables automatically and the print out is a record to be given to a client with regards to their payment. Once the code executes the data is no longer available for printing. It's very difficult to explain without complicated discussions. I use reports wherever practical, but in this case because of selections etc I doubt it could work. The user has no options other than click a print button or exit without action and only selects a client name from a combo box.
Regards
Malcolm