report setup

  • Thread starter Thread starter Richard
  • Start date Start date
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
 
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.
 
Hi Allen

Thanks for taking the time to reply.

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

Thanks again
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
 
Help | About will tell you what service pack is applied.

I still wouldn't trust Name AutoCorrupt anyway.
 
I am using Access 2003 with SP1. It doesn't say anything about SR1. Do I
need to patch?

Richard
 
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?
 
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.
 
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.
 
Back
Top