Home > IT Answers > Database > Access/Word Mail Merge Currency lost digits
OBI Girl
85 pts.
 Access/Word Mail Merge Currency lost digits
Database issues, Microsoft Access, Access 2007, Microsoft Word, Mail merge
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?
ASKED: Dec 3, 2008  8:42 PM GMT
UPDATED: January 27, 2009  3:09:29 PM GMT
RELATED QUESTIONS
SbElectric
2,510 pts.
Answer Wiki:
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.
Last Wiki Answer Submitted:  Dec 5, 2008  2:20 PM (GMT)  by  SbElectric   2,510 pts.
To see other answers submitted to the Answer Wiki View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



 

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.

OBI Girl
 85 pts.
 

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!

SbElectric
 2,510 pts.
 

Try the formula field in Word.
It may look like
{ =12345.23 # “$# ##0.00;($# ##0.00)” }

Msi77
 1,420 pts.
 

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.

OBI Girl
 85 pts.