MS Access Report Fields overlap on print

Posted on 2011-09-26
Last Modified: 2014-01-08
I support an Access application and recently several new machines were added that are Win 7 with Access 2007. The new machines print several fields on top of each other overlapping on the page when printed, they look fine in print preview! I suspect this is a printer driver problem since I can print the report from Win 7 on my Canon printers but the customers HP Laser Jet 5200 Series PCL 5 prints the overlapping fields. The customer has been printing these reports for years (and still can) on XP machines even with the same printer. If anyone knows of anything that can be done from within access please let me know.
Question by:vtechdev
  • 6
  • 5
LVL 26

Expert Comment

ID: 36601185
Print drivers can be a bugger.
Try opening the problem report on an XP-HP box and make a small change.
Undo the change.
Make sure it prints correctly on the XP-HP machine.
Then try on the Win 7 machine.

Ideally, the dev machine should be Windows 7 with BOTH printers installed.
The HP should be the default printer on the dev machine.

Give it a go, and post the results

Author Comment

ID: 36601477
Thanks for the idea, I'll try it but it will be a few days.
LVL 21
ID: 36601539
Also, what font(s)  are you using?
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.


Author Comment

ID: 36601662
Good thought on the fonts, I'm pretty sure they are all windows standard fonts, but I'll check.

Author Comment

ID: 39766300
I've requested that this question be closed as follows:

Accepted answer: 0 points for vtechdev's comment #a36601662

for the following reason:

because I have to clear this crap before asking another question and I pay good money for this service but no answer solved the problem totally unacceptable!
LVL 26

Accepted Solution

Nick67 earned 500 total points
ID: 39765615
I am sorry that your issue continues, but you have given us no feedback on our initial suggestions.  MS has done a pretty good job of providing WYSIWYG printing over the past 20 years, but it does occasionally fall down.  You will see, if you make a report use a specific printer, a dialog box that comes up when that printer is not available, asking you if Access should format the report for <<default printer>>  That message is clearly indicative that Access has to do some work when the printer last used in Design View isn't available at run-time.

The first step to troubleshooting is to throw the problem report on the problem machine into Design View, and make a small change, and save the result, and then print.  If that does the trick, then you have a root cause, and know how to deal with it.  As I noted, it is ideal to have the print driver that will be used in production on the dev machine, and set as the default.  You can do that without even having the actual printer attached to the machine.

But first, you have to try the suggestion and post feedback.  The key to getting good Answers is 1. Posting a detailed and concise Question (which you did!) 2.  Attempting solutions and posting feedback to you Experts and 3. Requesting attention (via the button just below your question if the Experts presently involved have run out of suggestions.


Author Comment

ID: 39766294
Hi Nick,
Thanks for the response, your ideas are good, but they are things I tried long before posting here. I realize that the community can only help if I keep providing detailed feedback, but when the suggestions are things at the beginning of my troubleshooting list I don't have time to keep dealing with them. My frustration isn't with you, it is with Experts Exchange. I pay them so I don't have to mess around with years old questions when something comes up.
I think it is about time to drop EE.
LVL 26

Expert Comment

ID: 39766604
It is always hard to know the skill level of the Asker when a question first pops up, and you know what they say about assume.  And in a troubleshooting volume defined by expense, difficulty, and likelihood of success, it is always good to start at free, easy and likely and move out from there.  I have 'reports' -- mailing labels for Okidata continuous forms -- that get VERY pissy if they are opened on a machine without that printer installed.  So much so that I have VBA code in place to force the driver, the paper size and all the margins on the damned things so that they work seamlessly for the end users -- but that is a very involved solution.

Intermediate to that is hooking your Win7 unit to the customer's HP physical printer to see if the problem follows the printer or the OS.

Other issues can include 64 bit vs 32 bit drivers and MS native drivers vs HP universal ones, so there are a lot of permutations that can result.

Other things to try are to share the Win7-HP printer.  Install the shared printer on a good XP box.  Then, from XP, share the shared printer, and install it back on the Win 7 box.  Print to that back-forth arrangement.  Does the job come out right when an XP box is in the loop for the print processing?

There are other possibilities to try as well -- but they are moving outward on the hassle/likelihood curve.

If the printer is shared on the Win 7 box, can the XP boxes print correctly to it over the network, or does it always bollux up the report regardless of where it comes form?

I have a good memory for detail, but not time flow.  Was this Q really from 2011, or has EE messed up the dates?

Is it still an issue that you'd like to solve?

Author Comment

ID: 39766654
The question really is that old, and the client has changed printers 2 or 3 times since!
I know Access can be very temperamental with print drivers and I'm familiar with how many variations there can be between OS, Microsoft vs HP etc.
If everything prints 8.5x11 the printer doesn't really matter with Access, but the second you have multiple reports in a project printing to multiple different printers in multiple sizes it all goes downhill pretty quick. The app in question has been ported to .NET against SQL Server so its a moot point. Thanks for taking the time to look into it, clearly you've been to same level of hell I had to visit.
LVL 26

Expert Comment

ID: 39766784
No Problem!
Sorry that I could not have been of timely assistance.

"The app in question has been ported to .NET against SQL Server ..."
Ported, or re-written to provide the same functionality?

I have a big, sprawling LOB app in Access against SQL Server Express.
I've found that ASP.Net is a huge jump in terms of struggling with syntax to do things that are fairly straight-forward to do in Access.  A desktop app in VB.Net might be simpler without the wrinkles of ViewState and postback.  What kinds of tools did you use in porting the app?

And most importantly, how did you replicate the report functionality?

Author Comment

ID: 39766800
Rewritten actually
Used Telerik controls and Telerik reporting. Not perfect, but not bad, and we resolved some other issues so the net outcome is a big improvement.
Although there were some rough parts in the conversion.
Access is a very powerful tool while the total number of users is low.
LVL 26

Expert Comment

ID: 39766812
We're up near 30 users, two in remote sites, now, so on the odd day there is pain.
Dev's have been asking MS for years for tools to move up from Access.
They don't seem to be listening.  They got their fingers stuck in their ears murmuring "SharePoint, SharePoint, SharePoint..."  but that's something that I won't touch with a stick.

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question