report printing chaos

[Mark]

Hello,

I have a problem with a report printout that is making my life very
difficult!

I have a report that prints cheque details onto a pre-printed cheque A4
sheet.

There are three cheques to the sheet and the details are held in a single
temp table record. i.e. the data repeats 3 times 8 fields per cheque.
The report layout is such that it prints correctly into the payee area value
box etc and is set out identically 3 times to match the pre printed page.
To make it fit I have had to set the to and bottom margins to 10mm.

This has worked well and over a week my client has printed 400 A4 pages no
problem, but now it is giving a random format problem, dropping the last
value onto a second page!

They have three PCs each with copy of the user file linked to a central data
source. Now if they try to print on another printer from a different PC
they are all doing the same.

I have tested and re-tested on my development system and have no problem at
all. I re-aligned all the controls on the report on my clients system and
did a test print and it worked OK. We then did a run of 4 pages and it then
printed out with all the values moved up the page, so I reverted to the
original version and it was fine for 10 pages and then went pear shaped
again!

What seems to happen is the top cheque prints OK the second cheque creeps
down by 7mm and the third creeps down by about 12 or 13.

We are using Access 2002 on windows XP machines on a windows 2000 server
standard edition with networked printers. Default printer HP laser Jet J6

Anyone out there with brilliant Ideas

Thanks

Mark


--
Open File Limited (Database Software, Automated Office Systems)

t: 01273 814409

w: http://www.open-file.co.uk

 

[Brendan Reynolds]

The depth of an A4 page is 297mm, and that number is not evenly divisible by
three. Take away 20mm for your 10mm top and bottom margins, and you're left
with 277mm, divide that by three and the height of your detail section would
need to be 92 and 1/3 mm. If, on the other hand, the bottom margin is
actually 11mm (a difference of one millimetre, which would be easy to
overlook) 297mm less 21mm for the two margins is 276mm, which divided by
three gives a detail height of a nice round 92mm.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.