So, did I just take off the "100*" and format all 90 fields to be percentages
with 0 decimals in Access for naught? Are you saying I'm going to have to
re-do all that in Word? I had to do that for each field, because I when I
selected more than one field in the query, it took away the format options.
It took a long time.
Now, will I have to make these switch changes in the table in Word
individually? I've never used one, but this nonsense makes me want to switch
to a mac. Please tell me how to cluster or select all the inserted fields I
want and "switdh" them all in one command.
Shannon
"Doug Robbins" wrote:
See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at
http://www.gmayor.com/formatting_word_fields.htm
--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.
Hope this helps,
Doug Robbins - Word MVP
"LacieMoon" wrote in message
...
Greetings! I have created a very simple merge from a query in Access that
merges into a table in Word. The problem is a field defined as currency in
Access does not "carry over" the formatting into the Word document. I can
put
a dollar sign in front of the field $Amount but I am dealing with
large
numbers and need the comma separators. Does anyone know how I can carry
over
the currency formatting from Access, OR correctly format the data field in
the Word table?
Thanks for any suggestions, Lacie