|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 1st, 2005, 12:02 AM
|
|||
|
|||
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
June 1st, 2005, 04:14 AM
|
|||
|
|||
|
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
June 1st, 2005, 06:58 PM
|
|||
|
|||
|
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
June 2nd, 2005, 05:40 AM
|
|||
|
|||
|
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!!!
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Form field errors when working on different computers Access 2000 format | andrew v via AccessMonster.com | Using Forms | 3 | March 23rd, 2005 06:23 PM |
| How can I format text in an Access memo field? | lvtosail | General Discussion | 1 | March 22nd, 2005 02:54 AM |
| Syntax needed to get needed reports | Frank Lueder | New Users | 15 | January 6th, 2005 08:39 AM |
| Upload Image | Jason MacKenzie | General Discussion | 1 | September 1st, 2004 04:38 AM |
| Using a "Currency" field from Access | Christopher | Mailmerge | 1 | April 30th, 2004 03:44 AM |
Linear Mode
