It may be that only IT admin personnel have the capability of making
the following changes.
Go into the list of Printers under the Settings button from the Start
menu. You may need to do this on the print server. Then click on
File >> Server Properties Then you can create a new form with the
sizes you want on it as well as a name.
Note that if you are taking the database between home and office you
will want to ensure the paper size name is absolutely identical right
down to the commas, spaces and periods.
Then you can follow the below steps inside Access to choose the just
created Paper Size. Go into the design of the report, Click
'File',Page Setup', Click the 'Page' tab., Select 'Specific Printer',,
Pick the printer you are using., Click 'Properties' then the 'Paper'
tab., In 'Paper Size' select 'Custom'. and choose your just created
Paper Size.
Tony
Thank you to everyone for their responses. Much appreciated.
THAT'S why I gave up on this solution. Without the ability to print
anywhere, esp. without fiddling, it renders this entire db useless.
So shelving this. I tried to get this to work at this new contract,
too, and I remembered then that I'd tried this before. Sorry my
memory is quite faulty sometimes, a problem I've had all my life ...
lesson learned: I didn't leave notes behind on why I stopped
developing this Access solution even though in every other respect, it
pretty much did the job.
However, things are much different now. We have many more options
esp. with regards to being able to use stuff off of a memory stick and
what will run on it. I have another db program that is now portable
and that allows us to create custom page sizes natively within the
program itself and not stupidly dependent on printers accessible on
host computers. I've always thought this was a serious Access
weakness and now doubly so. Ah well. As long as there's way to do
it even if not pertinent to this ng.
Thanks once again!
D
