| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Access currency field wont format correctly in word mail merge
I have a currency field in an Access 2003 database which when merged as a
mergefield in word will not format properly. The £ sign is not imported, neither is the decimal point or any decimal characters if the value is 0 (zero). Help it was easy in Access 2000!!! |
|
#2
|
|||
|
|||
|
Word is now expected to provide the formatting - 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 Marnee wrote: I have a currency field in an Access 2003 database which when merged as a mergefield in word will not format properly. The £ sign is not imported, neither is the decimal point or any decimal characters if the value is 0 (zero). Help it was easy in Access 2000!!! |
|
#3
|
|||
|
|||
|
Many Thanks for your help
"Graham Mayor" wrote: Word is now expected to provide the formatting - 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 Marnee wrote: I have a currency field in an Access 2003 database which when merged as a mergefield in word will not format properly. The £ sign is not imported, neither is the decimal point or any decimal characters if the value is 0 (zero). Help it was easy in Access 2000!!! |
|
#4
|
|||
|
|||
|
You are welcome
 -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Marnee wrote: Many Thanks for your help "Graham Mayor" wrote: Word is now expected to provide the formatting - 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 Marnee wrote: I have a currency field in an Access 2003 database which when merged as a mergefield in word will not format properly. The £ sign is not imported, neither is the decimal point or any decimal characters if the value is 0 (zero). Help it was easy in Access 2000!!! |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Syntax for Number format in the Text Form Field Options | Microsoft Word Help | |||
| Currency format in table. | Tables | |||
| How do I format numbers as Currency via Mail Merge? | Mailmerge | |||
| How do you keep the currency format when merging data from Excel? | Mailmerge | |||
| MailMerge with Access File - need to format currency | Mailmerge | |||
Linear Mode
