Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Jesse[_3_] Jesse[_3_] is offline
external usenet poster
 
Posts: 2
Default puzzling number format problem in conditional field

Thank you all for the help. Among other things, I learned about using
a comma in the switch. And, I now see that I was missing quote marks
around the format "picture", though formatting still works without the
quotes - sometimes.

And, http://www.gmayor.com/formatting_word_fields.htm is great.

With some more testing, I found that the "problem" - what causes the
"default" $ sign usage in the mail merge - comes from the data type in
the Access table. The data type is carried over, but the data field
properties are not. So a field that is set in Access to currency type
and to show there w/o $ is received by Word merely as a currency
number -- and so assumes that $ should be added. And, an Access
"number" type that has ".00" is truncated (by default) in Word -- so
"15.00" becomes "15" while "14.95" yields "14.95".

Peter, thanks for the a-b-c anecdotes -- there seems to be something
going on that may just be unknowable. And, it is good for me to see
that I am not the only one who writes in one message two paragraphs
that begin, "Finally..."

Again, thanks all. -- Jesse
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
Field codes: MergeField field RTF format problem Amdious Mailmerge 4 September 17th 07 02:38 PM
Conditional Currency/Text Field Format in Merge Suzamo Mailmerge 3 March 14th 07 11:06 AM
Number format field wordspinster Page Layout 1 August 5th 06 12:21 AM
How do i format how a number field displays? Maui Time Jen Mailmerge 2 September 14th 05 04:55 AM
Attaching Expansion Pack to Word Documents - Puzzling Problem Jose Microsoft Word Help 1 March 3rd 05 10:14 AM


All times are GMT +1. The time now is 12:31 PM.

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

About Us

"It's about Microsoft Word"