Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Format Currency
I have a Word merge document pulling from an Access Project view. In the
view, the field [Fund_Amt] is formatted as currency, but when it comes up in the Word document it's unformatted ($10,000.00 becomes 10000). I looked into switches, but didn't see one just for regular currency (although the dollar text one is really cool). |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Format Currency
It's \# . Try
{ MERGEFIELD Fund_Amt \#"$,0.00" } Peter Jamieson "Todd K." wrote in message ... I have a Word merge document pulling from an Access Project view. In the view, the field [Fund_Amt] is formatted as currency, but when it comes up in the Word document it's unformatted ($10,000.00 becomes 10000). I looked into switches, but didn't see one just for regular currency (although the dollar text one is really cool). |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Format Currency
YOU ROCK! That works perfectly, thanks.
"Peter Jamieson" wrote: It's \# . Try { MERGEFIELD Fund_Amt \#"$,0.00" } Peter Jamieson "Todd K." wrote in message ... I have a Word merge document pulling from an Access Project view. In the view, the field [Fund_Amt] is formatted as currency, but when it comes up in the Word document it's unformatted ($10,000.00 becomes 10000). I looked into switches, but didn't see one just for regular currency (although the dollar text one is really cool). |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Currency format is lost during Document Merge from Excel to Word. | Mailmerge | |||
Currency format | Mailmerge | |||
Access currency field wont format correctly in word mail merge | Mailmerge | |||
Syntax for Number format in the Text Form Field Options | Microsoft Word Help | |||
Currency format in table. | Tables |