p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   Textbox problem print preview vs. print (http://p2p.wrox.com/showthread.php?t=67769)

jenisageek April 29th, 2008 04:30 PM

Textbox problem print preview vs. print
 
I have a report in Access 2003 that has been working like a champ for time untold. A user today found that the report is breaking when run for a particular client.

The report includes residential and mailing addresses. On print preview, it appears exactly as it should:

Address: 1234 Any Way, Apt #13 City: Rancho Cordova

When actually printed, this is what is happening:

Address: 1234 Any Way, Apt #13Rancho Cordov City: a

I have done an update in the database to make sure there are no hidden or special characters to blame, and still the same problem. Print preview is perfect, but printed copy is mangled - though notice that the trailing "a" is spaced right where it should be. This behavior is the same across all the computers/terminals I've tried.

Any ideas?

mmcdonal April 30th, 2008 06:44 AM

More information about the one client's record? Any information on how the report is formatted? Where is this information being displayed? Group Header, Detail? Any formatting events in there? Any Can Grow, Can Shrink issues? What about Field Size issues? I assume that "1234 Any Way, Apt #13" is not the client's actual address. How many characters in that field, then?



mmcdonal

Look it up at: http://wrox.books24x7.com

jenisageek April 30th, 2008 01:12 PM

> More information about the one client's record?

As far as I can see, all data for this client is normal. Client records (tens of thousand) are highly normalized and standardized, an incomplete or corrupt record would be causing all kinds of other problems.

> Where is this information being displayed? Group Header, Detail?

It appears in the first group header (and I confirmed the query correctly returns just one row).

> Any formatting events in there?

None, there are sub-reports further down, but the address appears close to the top of page 1.

> Any Can Grow, Can Shrink issues?

Tried them each both ways (the address and the city fields) - no difference. Print preview looks fine, printed page is off.

> What about Field Size issues? I assume that "1234 Any Way, Apt #13" is not the client's actual address. How many characters in that field, then?

Definitely plenty of room. The address follows format:
#### Xxxxxxx Xxxxxx #13
Rancho Cordova

Something else I discovered this morning when trying to find a temporary workaround for the user is that if I take this same report, export to .snp (Snapshot) format, it gives the same problem, i.e. the .snp print preview looks fine, and the printed page is off, just as in Access.

Of course that led me to think the printer driver could somehow be to blame, but I've tested now on three distinct printers, two computers and one terminal. In the grand scheme it is a minor issue, but my frustration now won't let me drop it until I solve this.

Thanks for your help!

SerranoG May 2nd, 2008 07:04 AM

What about installed fonts? Does the client have the same fonts installed you do and are the printers vastly different? If not, is it possible the printer driver for the client is trying to approximate the best font to use instead of yours and causing the glitch?


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

lryckman May 2nd, 2008 07:47 AM

Hello all!

I have similar issues, but no resolution for them. Mine has progressed to printing issues across all office programs on my PC, but other users only face this within Access. Ours is specific to one printer and if we print to a different printer, it works fine. I believe it to be a print driver issue, but I also think my PC has additional conflicts with it. All our printers are contracted from the same manufacturer and their support group has not been able to find an issue with the print driver, but they also were not too thrilled with me assuming the print driver had an issue and didn't spend too much time with troubleshooting. ;)
(Hopefully I'll be getting my other PC soon so I can see if that helps!)

One work-around I have found for my issue is exporting the report as a snapshot file, and then printing the .snp file. It prints fine for me and hopefully will allow you to continue using your reports until a solution is found.

I hope my information and work-around provide some kind of assistance for you.

Have a great weekend!!!

Regards,
Laura

FYI...My user id has changed. My old id was lbreitenbach

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!

jenisageek May 2nd, 2008 12:54 PM

Thanks for the feedback. At this point it does look like a font/printer driver issue. I'm befuddled that it shows up only in this one spot of this one report for this one particular client, but I suppose that's the nature of a bug :)

It looks like the HP printer drivers don't like the Tahoma font - 3 different printers tried, but all HP. Looks like we'll be changing the report to a different font, as both Arial and Verdana seem fine.

Pesky!

Thanks again!


All times are GMT -4. The time now is 10:42 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.