Paper Size Problem

[millwheal]

I am using Access 2003, running under Windows XP SP3. I do not know whether this is an Access problem or not, but cannot find any suggestions anywhere for a solution.
A user modified a report and has problems with the new version. In trying to resolve these, I set up a db with both the original and amended versions of the report.
The report is supposed to print on the default printer, set for A4 paper. For unknown reasons, the paper size is set to 'Letter' in both versions. Both the user's and my default printer properties are set to A4 paper.
When I change the paper size [using File/Page Setup], the original report accepts the change, but the amended report will not accept it and continually reverts back to 'Letter'.
When I make the change on the amended report, it appears to accept it, and when I close the report, it asks if I want to save changes. However, when I then reopen the report [design mode], the paper size has reverted to 'Letter'. If I make the change and then immediately go back into File/Page Setup, it has already reverted back to 'Letter'. I have tried changing to a different size, e.g. A3, but the same thing happens. I can change the paper 'Source' and this change is accepted.
As far as I am aware, the only difference between the two versions of the report is the position of a couple of fields on the page.
Can anyone offer an explanation?

 

[Alisa]

I have fought with this before. It seems buggy. I am not entirely sure I understand your description, but have you tried going into the report and under page setup change the printer to default and then save it? I don't know if it will help, but I have a vague memory of trying that once before . . . If that doesn't work, you could also manually set the print settings in code, but that would be a lot more work.

 

[millwheal]

As I said in my original submission, I have gone through File/Page Setup and then immediately saved the report, but it still reverts back to 'Letter'. It doesn't matter whether I choose the default printer or another printer, whether I immediately save the report object or close it and click on 'Yes' to save it, it always reverts to 'Letter'.
The problem only seems to occur with this particular object and with no others, not even the original report from which the problem report was copied.

 

[Alisa]

Yeah, it sounds like you may have to resort to setting it in code. Sorry I don't have any easier suggestions for you.