Reply
 
Thread Tools Display Modes
  #1   Report Post  
Marnee
 
Posts: n/a
Default 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   Report Post  
Graham Mayor
 
Posts: n/a
Default

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   Report Post  
Marnee
 
Posts: n/a
Default

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   Report Post  
Graham Mayor
 
Posts: n/a
Default

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Syntax for Number format in the Text Form Field Options Ed Hall 61 Microsoft Word Help 3 May 8th 05 07:51 PM
Currency format in table. Jeff Stroope Tables 1 April 23rd 05 12:17 AM
How do I format numbers as Currency via Mail Merge? SteveL67 Mailmerge 1 March 3rd 05 05:32 PM
How do you keep the currency format when merging data from Excel? MJW Mailmerge 2 February 22nd 05 06:33 PM
MailMerge with Access File - need to format currency TheMomBon Mailmerge 1 January 26th 05 04:47 PM


All times are GMT +1. The time now is 08:10 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"