access report designed in 2000 throwing extra page in 2003

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

Hi,
Firstly , sorry if this appears twice as I posted it through the Microsoft
Web site and after 2 hours it still had not appeared so I am trying through
the newsgroup.
The problem :
I have a report designed in access 2000. Many access 2000 users are printing
it without problem. A new access 2003 installation is now trying to print it
and the left margin appears to be bigger and thus the right side of the
report is thrown onto an extra page.
Changing the pargins under "Tools > Options" has not effect and I would
prefer not to mess with the design of the report for fear of "breaking" it
for the other users.
Any idea why Access 2003 would print the report differently and how to "fix"
it?
Thanks,
Sean.
 
Sean said:
Firstly , sorry if this appears twice as I posted it through the Microsoft
Web site and after 2 hours it still had not appeared so I am trying through
the newsgroup.
The problem :
I have a report designed in access 2000. Many access 2000 users are printing
it without problem. A new access 2003 installation is now trying to print it
and the left margin appears to be bigger and thus the right side of the
report is thrown onto an extra page.
Changing the pargins under "Tools > Options" has not effect and I would
prefer not to mess with the design of the report for fear of "breaking" it
for the other users.
Any idea why Access 2003 would print the report differently and how to "fix"
it?
Click to expand...


I don't think Access does that, this kind of thing is almost
always a printer issue. Are the two machines using the same
printer and driver?

You said you reset the margins in the report, did you try to
make them smaller? Did the margin changes "take" or did
they jump back to what they were before?
 
Hi,
The printer is a shared printer hanging off an NT server and is the same
printer that all others use. The driver is the same as it was installed from
the same install CD. The OS version is XP Pro on all machines in question so
the driver is the same on all. I have therefore assumed it is not a problem
with printer or driver ?

The margin setting I changed was in Access 2003 itself under "Tools >
Options" . I did not try and adjust the margins in the report design itself
in case it caused a problem for all the other users who are currently
printing this report fine.
 
Sean said:
The printer is a shared printer hanging off an NT server and is the same
printer that all others use. The driver is the same as it was installed from
the same install CD. The OS version is XP Pro on all machines in question so
the driver is the same on all. I have therefore assumed it is not a problem
with printer or driver ?
Click to expand...

The first thing I would do here is double check the driver
version on the troublesome machine against the other
machines.

The margin setting I changed was in Access 2003 itself under "Tools >
Options" . I did not try and adjust the margins in the report design itself
in case it caused a problem for all the other users who are currently
printing this report fine.
Click to expand...

The Tools - Options margin number are only used as defaults
for new reports and would have no effect on an existing
report.

Just as an experiment, try making the margins smaller on the
problem machine, then check to see if they "take" or if
they're reset to a value larger than what they are on the
eother machines.
--
Marsh
MVP [MS Access]


 
Sean

In addition to Marsh's suggestions...

I can't tell from your description whether your database is split, and
whether or not all users share the same front-end, or each uses his/her own
copy. The latter is recommended, as the former will cause problems.

Just a thought...
 
Back
Top