Access/Word Mail Merge Currency lost digits

85 pts.
Tags:
Database issues
Mail merge
Microsoft Access
Microsoft Access 2007
Microsoft Word
I made a Donations database which merges with a Word document that provides a receipt. The data that comes over drops zeros after the decimal. Ex: $700.00 appears as $700 ...Even worse $700.60 appears as 700.6 How do I get the decimals to show?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Check the data type. Open the table in design mode & then click on the particular field name. Make the Data Type “Currency” from the Drop-Down list.
Hope it works.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • OBI Girl
    Data type is already set to currency. I'm wondering if there's something I need to do in the Word doc. to tell it how I want the amount formatted. But I can't seem to find a way to do that.
    85 pointsBadges:
    report
  • SbElectric
    It should work - I am puzzled too. The other item that I can think is in addition to Currency, set the decimal place to 2. Open the report in design mode; click on the field that you are having problem with & right click & then select Properties. Now select Currency from the Drop down Format field. I am assuming you are printing the Report via Access Report not from Word. Good luck!
    2,540 pointsBadges:
    report
  • msi77
    Try the formula field in Word. It may look like { =12345.23 # "$# ##0.00;($# ##0.00)" }
    1,670 pointsBadges:
    report
  • OBI Girl
    BINGO!! Thank you so much Msi77! I am printing the letters from Word. I had to add a Numeric Format Switch to the field code.
    85 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following