Printing a Report 2" X 4"

[DAB]

I am using a DB where you select members that have signed up for and art
event and print labels using a Dymo printer. The label contains member info,
art info, and calculations for sales tax and totals. My problem is that if I
make a Label report the calculations do not work the same a making a report.
How do I size a report for a 2" X 4" report, which is the Dymo label I want
to use, or how do I make calculations work on a label report?
Thanks for any help you can provide.

 

[Arvin Meyer [MVP]]

The Dymo printer should have software that creates the 2"x4" label size. You
may set a report to be any size.

 

[Tom Wickerath]

Hi Doug,

What do you mean by "if I make a Label report the calculations do not work
the same..."? Are you getting an error displayed, such as #Error, instead of
the calculated result? You might check your project for any missing
references. The reason I say this is that the label wizard includes the Trim
function. If you have a missing reference, this function will not run. If
that's happening, then the calculation may also not be working properly. When
you create a regular report, chance are you are not using any VBA functions,
such as Trim.

Solving Problems with Library References (Allen Browne)
http://allenbrowne.com/ser-38.html

Access Reference Problems (Doug Steele)
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html



Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Guest]

I am using a DB where you select members that have signed up for and art
event and print labels using a Dymo printer. The label contains member
info,
art info, and calculations for sales tax and totals. My problem is that
if I
make a Label report the calculations do not work the same a making a
report.
How do I size a report for a 2" X 4" report, which is the Dymo label I
want
to use, or how do I make calculations work on a label report?
Thanks for any help you can provide.