Problem with report page setup

[Chubbly Geezer]

Hi

I have numerous reports within a 2000 database all designed to print on A4.
However these seem to now have paper size of 'letter' selected.

1] I'm not sure why this has happened
2] I am unable to change back. I can access file-->page setup and change
entries including paper size, but they are not being saved.

Any ideas please.?

 

[Wayne Morgan]

What printer is selected and is that printer capable of printing on A4?

 

[Allen Browne]

Firstly, make sure that your printer is set to default to A4 paper in
Windows, i.e. under:
Start | Programs | Printers and Faxes.

Secondly, uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
This is a known cause of this problem. More detail:
http://allenbrowne.com/bug-03.html
Then compact the database to get rid of this junk:
Tools | Database Utilities | Compact

Thirdly, make sure you have downloaded SP3 for Office 2000 *and* SP8 for JET
4. Both are available from:
http://support.microsoft.com/gp/sp

 

[Chubbly Geezer]

Apologies Allen. I'm actually opening an Access 2000 database with Access
2003.

Firstly, make sure that your printer is set to default to A4 paper in
Windows, i.e. under:
Start | Programs | Printers and Faxes.

Secondly, uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
This is a known cause of this problem. More detail:
http://allenbrowne.com/bug-03.html
Then compact the database to get rid of this junk:
Tools | Database Utilities | Compact

Thirdly, make sure you have downloaded SP3 for Office 2000 *and* SP8 for
JET 4. Both are available from:
http://support.microsoft.com/gp/sp

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Hi

I have numerous reports within a 2000 database all designed to print on
A4. However these seem to now have paper size of 'letter' selected.

1] I'm not sure why this has happened
2] I am unable to change back. I can access file-->page setup and change
entries including paper size, but they are not being saved.

Any ideas please.?

 

[Chubbly Geezer]

OK..

Database converted to 2002-2003 format
Printer defaults to A4
All AutoCorrect options unchecked
All current SP's installed

Still the same problem

Firstly, make sure that your printer is set to default to A4 paper in
Windows, i.e. under:
Start | Programs | Printers and Faxes.

Secondly, uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
This is a known cause of this problem. More detail:
http://allenbrowne.com/bug-03.html
Then compact the database to get rid of this junk:
Tools | Database Utilities | Compact

Thirdly, make sure you have downloaded SP3 for Office 2000 *and* SP8 for
JET 4. Both are available from:
http://support.microsoft.com/gp/sp

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Hi

I have numerous reports within a 2000 database all designed to print on
A4. However these seem to now have paper size of 'letter' selected.

1] I'm not sure why this has happened
2] I am unable to change back. I can access file-->page setup and change
entries including paper size, but they are not being saved.

Any ideas please.?

 

[Allen Browne]

If you have Access 2003, press Ctrl+G to open the immediate window.

Enter:
? Printer.PaperSize

If you do not get 9 (i.e. acPRPSA4), you have not correctly set the paper
size of your default printer to A4.

The file format is not relevant, but the printer settings are.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

OK..

Database converted to 2002-2003 format
Printer defaults to A4
All AutoCorrect options unchecked
All current SP's installed

Still the same problem

Firstly, make sure that your printer is set to default to A4 paper in
Windows, i.e. under:
Start | Programs | Printers and Faxes.

Secondly, uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
This is a known cause of this problem. More detail:
http://allenbrowne.com/bug-03.html
Then compact the database to get rid of this junk:
Tools | Database Utilities | Compact

Thirdly, make sure you have downloaded SP3 for Office 2000 *and* SP8 for
JET 4. Both are available from:
http://support.microsoft.com/gp/sp

Hi

I have numerous reports within a 2000 database all designed to print on
A4. However these seem to now have paper size of 'letter' selected.

1] I'm not sure why this has happened
2] I am unable to change back. I can access file-->page setup and
change entries including paper size, but they are not being saved.

Any ideas please.?

 

[Chubbly Geezer]

I do indeed get 9

If I create a new report paper size defaults to A4. Just cannot change the
existing reports.

If you have Access 2003, press Ctrl+G to open the immediate window.

Enter:
? Printer.PaperSize

If you do not get 9 (i.e. acPRPSA4), you have not correctly set the paper
size of your default printer to A4.

The file format is not relevant, but the printer settings are.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

OK..

Database converted to 2002-2003 format
Printer defaults to A4
All AutoCorrect options unchecked
All current SP's installed

Still the same problem

Firstly, make sure that your printer is set to default to A4 paper in
Windows, i.e. under:
Start | Programs | Printers and Faxes.

Secondly, uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
This is a known cause of this problem. More detail:
http://allenbrowne.com/bug-03.html
Then compact the database to get rid of this junk:
Tools | Database Utilities | Compact

Thirdly, make sure you have downloaded SP3 for Office 2000 *and* SP8 for
JET 4. Both are available from:
http://support.microsoft.com/gp/sp

Hi

I have numerous reports within a 2000 database all designed to print on
A4. However these seem to now have paper size of 'letter' selected.

1] I'm not sure why this has happened
2] I am unable to change back. I can access file-->page setup and
change entries including paper size, but they are not being saved.

Any ideas please.?

 

[Wayne Morgan]

New reports will use the default printer unless you specify another one. The
existing reports may have had a printer specified. If so, does that printer
support A4? Does that printer even still exist?

 

[Chubbly Geezer]

Some reports have a specified print, which does exist and does support A4.
Some reports use default printer, which on my workstation does exist and
support A4.

 

[Allen Browne]

Open the report in design view.
Choose Page Setup from the File menu.
Make sure the option on the 2nd tab is set to:
Default Printer
Save the changes.

If the report is set for the default printer, and the default printer is set
for A4, I don't see how it can miss unless there is some code that is
messing with it.

 

[Chubbly Geezer]

The report is set for the default printer, and the default printer is set
for A4. The report paper size however is stuck on 'letter' and no matter
how many time I change the value it is not saved. Have tried manually and
via code.

 

[Allen Browne]

If everything is as you say, I can only assume that the report is corrupt.

1. Create a new (blank) database.

2. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect

3. Create a new report (no table), and check that it defaults to A4. No need
to save it.

4. Import the tables, queries, and forms (but not reports) from the bad
database:
File | Get External | Import

5. Close this database.

6. Open the old database, and export your reports to text files, using:
SaveAsText acReport, "Report1", "C:\Report1.txt"
etc.

7. Open the new database, and import the reports from the text files:
LoadFromText acReport, "Report1", "C:\Report1.txt"

 

[Chubbly Geezer]

In that case I have many dozen corrupt reports. Exporting and importing
does not solve the problem.

 

[Allen Browne]

Chubbley, I don't think there is anything else I can suggest for you.

Reading back over this thread, it turns out you are using A2003. If this is
a network printer, you might like to try deleting it from your Windows
printer, and then install it as if it were a local printer, even though it
is not physically connected to LPT1:. There is a problem with network
printers on A2003, with some quite weird side effects.

If that does not help, I am out of ideas.

 

[Chubbly Geezer]

OK cheers Allen. Thx for your suggestions.

Chubbley, I don't think there is anything else I can suggest for you.

Reading back over this thread, it turns out you are using A2003. If this
is a network printer, you might like to try deleting it from your Windows
printer, and then install it as if it were a local printer, even though it
is not physically connected to LPT1:. There is a problem with network
printers on A2003, with some quite weird side effects.

If that does not help, I am out of ideas.

 

[Douglas J Steele]

Might it help if he deleted the 3 printer-related sections from the report
after exporting and before importing (i.e.: between steps 6 and 7 below)?

I'm talking about the sections

PrtMip = Begin
0xa0050000a0050000380400003804000000000000932400009501000001000000 ,
0x010000006801000000000000a10700000100000001000000
End
PrtDevMode = Begin
0x6870343400000000000000000000000000000000000000000000000000000000 ,
0x200301037c007000034b01000100010000000000000001000f00000002000100 ,
0x0000020000004c65747465720000000000000000000000000000000000000000 ,
0x000000000000000000000000000000000000000000000000000000002000ffff ,
0xffffffff00000000000000000000000000000000060003001b00ffff0000ffff ,
0x08000100ffff040001000000ffff01000200ffffffffffffffffffffffffffff ,
0xffffffffffffffffffffffffffffffff00000000180000000000102710271027 ,
0x000010270000000000000000
End
PrtDevNames = Begin
0x080011001600010077696e73706f6f6c0068703434004c5054313a0000000000 ,
0x000000000000000000000000
End

that should be near the top of the saved report.