Badge printing inside MS Access

Posted on 2006-11-04
Last Modified: 2008-03-06
I am using MS Access as a front end to print Employee Badges.
If I print a test / demo badge from the printer itself, or from a photo shop style appication, all is fine.
However with MS Access it prints .006 margin left & right.
How do I fix this?
Question by:Russ Cummings
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
  • 2
  • 2
LVL 61

Expert Comment

ID: 17872953
You can change the margins in Access from Access's toolbar when viewing your report in preview or design view:

File -> Page Setup

(assuming you are printing the badges through an Access Report)

Author Comment

by:Russ Cummings
ID: 17873125
Yes, Thanks, but that is not the answer.  I need to set the margins at zero, Access will not allow this, but other apps do.  
Is there a way around it?
LVL 61

Expert Comment

ID: 17873679
AFAIK, You can't set the print margins to 0 in Access 2000 or higher.

This is somewhat related:
LVL 38

Accepted Solution

puppydogbuddy earned 250 total points
ID: 17882030
In  order to negate the effect of the limitation on the margin, you can experiment with different fonts, and with changing the scaleWidth and scaleHeight properties until you achieve the same presentation effect.

Author Comment

by:Russ Cummings
ID: 17886953
Thank you, I will try that & let you know.

Featured Post

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

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

Suggested Solutions

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

732 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