report setup

R

Richard

Hi

I have a report that uses a paper size of "cheque". When I preview the
report, it comes out as "cheque". But when the front-end is distributed, the
preview comes out as something else and the user needs to go to setup and
reset the paper size.

I have turned off the Auto Correct check box, but the problem persists. How
do I overcome this issue? Can we set the page type using code?

Thanks in advance
Richard
 
A

Allen Browne

The paper sizes available to print depend on your printer. If your users had
exactly the same printer, and operating system, and printer driver, what you
are trying to do might work. However, if any one of those is different, it
won't match.

BTW, Access 2002 and later are aware of 42 different paper sizes, but
"cheque" is not one of them.
 
R

Richard

Hi Allen

Thanks for taking the time to reply.

The users are all using the same printer, operating system.

Thanks again
Richard
 
R

Richard

Hi Allen

They are using my "shared printer". Anyway there's only one printer in the
office so I assume it would be the same driver files, right?

The Auto correct is off, and how do I know if I did the SR1 patch. I thought
I did all the patches, not sure now.

regards
Richard
 
A

Allen Browne

Help | About will tell you what service pack is applied.

I still wouldn't trust Name AutoCorrupt anyway.
 
R

Richard

I am using Access 2003 with SP1. It doesn't say anything about SR1. Do I
need to patch?

Richard
 
A

Allen Browne

SP2 has just been released for Office 2003.

According to the MS documentation, this particular issue was fixed well
before that, though I still won't trust Name AutoCorrect anywhere near any
of my databases because it has so many problems and still causes A2003 to
crash and corrupt:
http://allenbrowne.com/bug-03.html

Could you use a standard page size divided into 3 or 4 cheques?
 
R

Richard

If I use a standard page size as you suggest, how would I feed the cheque to
the printer?
 
A

Allen Browne

Yes, it would feed 3 or 4 at a time, which won't be useful unless you print
in batches.

Not sure what else to suggest.
 
A

Allen Browne

Yes, it would feed 3 or 4 at a time, which won't be useful unless you print
in batches.

Not sure what else to suggest.
 
Top