Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
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? |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
format column for currency
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? |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
format column for currency
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? |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
format column for currency
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? |
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
format column for currency
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? |
#6
Posted to microsoft.public.word.tables
|
|||
|
|||
format column for currency
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? |
#7
Posted to microsoft.public.word.tables
|
|||
|
|||
format column for currency
{ 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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format Currency | Mailmerge | |||
Currency format | Mailmerge | |||
Currency fields in Access lose th currency format whn merged why | Mailmerge | |||
Currency format in table. | Tables | |||
how to format currency | Mailmerge |