[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now


MS Access Report Fields overlap on print

Posted on 2011-09-26
Medium Priority
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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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?
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!


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 1000 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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

656 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