How can I do away with the decimal in a report to print a pre-printedform?

R

Ron

Hi All,

I have a requirement to print amounts (dollars and cents but without
the
dollar sign) without the decimal. So, 444.44 would become 44444. A
pre-printed form I need to print with these amounts on them has an
assumed
position for the dollars and cents, and there's no room for a
decimal. So they don't want the period.

Anyway to easily accomplish this feat?

TIA,
ron
 
A

Allen Browne

Try a text box with properites like this:
Control Source: = 100 * [YourCurrencyField]
Format: Fixed
Decimal Places: 0

Make sure the Name property of the text box is not the same as the field
name.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Return Only the Numbers in a Text Field (Plus the Decimal) 9
How do I print a word doc without the header and footer? 3
How do I print query parameters on the report? 2
how do I force a report page to print over 2 pages in Access? 3
How do I print only the selected items on a form in Word? 1
How do I get a report to print the contents of 'FieldA' .... 4
How do I print a report within a form from the data in the form? 1
Living With a Computer 3

Top