 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / November 2006Format 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). It's \# . Try { MERGEFIELD Fund_Amt \#"$,0.00" } Peter Jamieson >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 [quoted text clipped - 4 lines] > dollar > text one is really cool). YOU ROCK! That works perfectly, thanks. > It's \# . Try > [quoted text clipped - 10 lines] > > dollar > > text one is really cool). |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.