format column for currency

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?

You will need a currency formatting switch on the field(s) in your table eg

{Mergefield CurrencyFieldName \# "$,0.00"}

see http://www.gmayor.com/formatting_word_fields.htm


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org

Rick wrote:
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?

How do I do it so it is decimal aligned but doesn't have the dollar signed?

"Graham Mayor" wrote:

You will need a currency formatting switch on the field(s) in your table eg

{Mergefield CurrencyFieldName \# "$,0.00"}

see http://www.gmayor.com/formatting_word_fields.htm


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org

Rick wrote:
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?

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

"Rick" wrote in message
...
How do I do it so it is decimal aligned but doesn't have the dollar
signed?

"Graham Mayor" wrote:

You will need a currency formatting switch on the field(s) in your table
eg

{Mergefield CurrencyFieldName \# "$,0.00"}

see http://www.gmayor.com/formatting_word_fields.htm


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org

Rick wrote:
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?

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

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Rick wrote:
How do I do it so it is decimal aligned but doesn't have the dollar
signed?

"Graham Mayor" wrote:

You will need a currency formatting switch on the field(s) in your
table eg

{Mergefield CurrencyFieldName \# "$,0.00"}

see http://www.gmayor.com/formatting_word_fields.htm


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org

Rick wrote:
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?

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!

"Doug Robbins - Word MVP" wrote:

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

"Rick" wrote in message
...
How do I do it so it is decimal aligned but doesn't have the dollar
signed?

"Graham Mayor" wrote:

You will need a currency formatting switch on the field(s) in your table
eg

{Mergefield CurrencyFieldName \# "$,0.00"}

see http://www.gmayor.com/formatting_word_fields.htm


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org

Rick wrote:
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?

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

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Rick" wrote in message
...
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!

"Doug Robbins - Word MVP" wrote:

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

"Rick" wrote in message
...
How do I do it so it is decimal aligned but doesn't have the dollar
signed?

"Graham Mayor" wrote:

You will need a currency formatting switch on the field(s) in your
table
eg

{Mergefield CurrencyFieldName \# "$,0.00"}

see http://www.gmayor.com/formatting_word_fields.htm


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org

Rick wrote:
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?