format column for currency

R

Rick

I am using a table in Word, which draws from an access database into a column
in the table. All the numbers in the column are currency. For some reason
the word merge form doesn't draw the currency numbers correctly from the
database, even though they are correctly currency in the database.
I thought something might be wrong in the formatting of the column. I want
the column to be 2 decimal places aligned to the right and have a $ symbol.
I can't get this to work.
I want it to look somewhat like this:
column 1 $ 4.00

any suggestions?
 
D

Doug Robbins - Word MVP

use {Mergefield CurrencyFieldName \# ",0.00"}

With a decimal tab and the paragraph format set to left aligned.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 
G

Graham Mayor

Use a decimal (or right) tab to position the field and remove the dollar
sign from the switch

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
R

Rick

I'm not sure I understand what you mean by {Mergefield CurrencyFieldName}
Do I need to rename the mergefield that is being imported by Access or add
this name to the field name?
Thanks!
 
S

Suzanne S. Barnhill

{ Mergefield CurrencyFieldName } means that you substitute whatever the name
of your field is for "CurrencyFieldName."
 
Top