Rpt on 2000 = Great ! Rpt on NT = Problem ! What's up?

[saustin]

Hi All,
Have a bizzare problem where a report will work great on any win2000 workstation but copy it over to a nt workstation and the landscape report runs over to a second page. Has anyone seen this before ? Tried another nt workstation with the same result. No problem with copying it to another 2000 workstation.
Can re-write the report for a quick fix but would love to know what is wrong. Thanks, Steve.

 

[JohnLowell]

Are they both using the same printer and printer driver?

Some printer drivers have different defaults for margins.

 

[saustin]

Hi John,
Just tested it out and same result using the identical driver. The code does change properties at runtime.

Me!VENDOR_ID.FontBold = True
Me!VENDOR_ID.FontWeight = 900
Me!VENDOR_ID.ForeColor = vbRed
Me!VENDOR_ID.BackColor = 12632256

Am able to create a new form + txtbox and prove to myself that this computer can display settings used in the vba report code.

The report displays to the screen so I can send 7 copies to this new 36 ppm hp laser printer we got in.

 

[JohnLowell]

Double check your left margin, right margin and report width, making sure they don't add up over 11 inches.

I know this sounds basic, but you wouldn't believe how many times this has happened.

Let me know how things work out.

 

[saustin]

John,
Margins and width are the same on both NT and 2000 workstations. Am really stumped here. Steve

 

[saustin]

John,
Mystery Solved ! Should have figured it out sooner. Fonts are different between NT and 2000. Just copied over the Arial fonts from 2000 and voila .... it works. Thanks for the inspiration. Steve.