Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 267
  • Last Modified:

Access 2003 Fitting data to a Avery business card.

I have an app that prints out an id card front and back . we cut it and fold then laminate and its good to go. My problems are that i get 1 per page and they would fit on an avery business card.  I have the sizing right (almost) but am not able to get mult on 1 page. In design view the Report header is closed , Page header is closed, detail has my fields and graphics, Page footer and report footer are closed and empty. I would almost bet that there is a proprty I am ignorant about that would make this all work...Please enlighten me..
0
SteveMcCoyOregon
Asked:
SteveMcCoyOregon
  • 2
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Access has a "Label Wizard" you can use to build a report, then format that to match the size of your Avery label. Select the Reports tab in the database window, click "Create Report by using Wizard", then select "New" (don't just doubleclick the "Create Report" line, make sure to click the New button). You can then select the Label Wizard selection, choose your table/query, then build the report. Access has a lot of different formats which match the Avery sizes, and even uses the Avery number designation.
0
 
Jeffrey CoachmanMIS LiasonCommented:
<No points wanted>

LSM has your answer.

FWI, Basically the Wizard uses the "Colums" option from the Page setup Dialog box to fill the "Page" with cards.

JeffCoachman
0
 
SteveMcCoyOregonAuthor Commented:
looks like the formats is good -not sue about left right/ front back paging though.
0
 
SteveMcCoyOregonAuthor Commented:
I was able to easily solve my issue thanks to the pointers provided. I made a custom label representing a large 1 up label so my front back issues were satisfied. THANKS For the quick reply.

Steve
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now