Changing "Custom Paper Size" in MS Access

[CSADataCruncher]

I'm trying to change the paper size in MS Access to 5.5 by 8.5 inches (so, basically 1/2 letter size). After I achieve this paper size change I will also need advice on how to create a "2-up" file in pdf format.

In the page setup of my report, I see that one of the choices is postscript custom but I don't see how to "customize" it once I make this selection.

Once I get my report to print to this 1/2 page size, I will need two images per page on the pdf file.

The reason I do not use the 2 column feature is that I'm really trying to create a book and the printer wants 2 copies of page one on a page, 2 copies of page two on a page, etc. and I don't want Access to get confused.

Can you help?
Peggy
CSADataCruncher

 

[mp9]

With regard to setting papaer size in code, there are two possibilities to search Access VBA help for: PaperSize which is a property of Application.Printer and PrtDevMode.

Hope this helps.

 

[BoxHead]

I don't think you have to change the papersize in Access.

You should be able to use the page setup from the Report screen to select a specific printer (PDF Writer) and on the Properties tab for the PDF Writer, select "Booklet".

Do you already have the report printing duplicate records?

Getting "2 copies of page one on a page" is probably going to be a bigger issue. Off the top of my head, you would have to duplicate the records in your query. Creating a new table tbl2Int with one field and two records, you could add the table to your query. No joins - you wouldn't even have to add the field to the query. As long as the new table only has two records.

HTH




John