Reply
 
Thread Tools Display Modes
  #1   Report Post  
PMasters
 
Posts: n/a
Default Currency fields in Access lose th currency format whn merged why

Can anyone help cure this formatting problem? Fields in Access selected as
currency fields merge without commas and dollar sign ending up in the merged
document.

Thanks
  #2   Report Post  
Peter Jamieson
 
Posts: n/a
Default

Word is now expected to provide the formatting for numeric and date fields.

e.g. if you use Alt-F9 to display the field codes and have a field such as

{ MERGEFIELD mynumber }

you can type a "numeric formatting switch" to add formatting info, e.g.

{ MERGEFIELD mynumber \#"$,#.00" }

These formatting switches are documented in Word Help.

Peter Jamieson

"PMasters" wrote in message
...
Can anyone help cure this formatting problem? Fields in Access selected
as
currency fields merge without commas and dollar sign ending up in the
merged
document.

Thanks



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
Access currency field wont format correctly in word mail merge Marnee Mailmerge 3 June 2nd 05 05:40 AM
How to insert only selected fields from Access database in Word? RenèJ Microsoft Word Help 1 May 23rd 05 09:10 PM
Currency format in table. Jeff Stroope Tables 1 April 23rd 05 12:17 AM
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 10:12 PM.

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"