Custom paper size

[johnaaronrose]

I'm using a Panasonic KXP2130 printer and Access 2000 SP-3. I want to use a custom (i.e. user defined) size paper (actually Letter width but half Letter height i.e 8.5" width & 5.5" high).

To define a custom paper size: I bring up Design view of the report. I click on File & Page Setup to bring up the Page Setup dialog box. I click the Page tab and there is no obvious mechanism to setup a custom Paper Size. So I click the 'Use Specific Printer' radio button & click the 'Printer...' button. In the resultant 'Page Setup' dialog box, I set the printer to Panasonic KXP2130 and I click the 'Paper/Quality' tab and the 'Advanced...' button and there is still no mechanism to set a custom paper size.

It seems strange that Access wouldn't allow a custom paper size for a dot matrix printer (in a similar way to that used with Word). Am I missing something very obvious / can it be done by (for example) VBA?


John Rose

 

[Aubs010]

I think the paper sizes comes from the default printer. If that printer has a custom size set up, then access will allow you to select that page size. If you change printers, then access will allow you to select the paper sizes from that printer...

If you understand what I'm getting at!

Aubs

 

[johnaaronrose]

In Word 2000, using Panasonic 2130 as the printer (or even the default printer) the Width & Height are shown on the Page Setup dialog box and may be changed. However, Access 2000 does not show them in its Page Setup (for Report Design), let alone allow them to be amended.

Does this make the problem clearer?

John Rose

 

[Aubs010]

Can you not simplly control the page size with the report in design view? Move the borders to one side etc?

Otherwise I've no idea, I'm sorry

Aubs

 

[DrSimon]

John, I think Aubs is right - the only way to do what you want is as he describes by setting up custom stationery. Word has that functionality because it's a word processing application; there are many things that Word does that Access can't ........ but try to do multiple joins in Word!