Access typically /stores/ the "raw" data (e.g. $1,234.00 is just stored as a
binary number representing 1234.00) and uses other information to display
the fields correctly within Access. Typically, Word gets the raw data. You
can format it in Word field by editing the field codes (use Alt-F9 to
toggle) , e.g. change
{ MERGEFIELD myamount }
to
{ MERGEFIELD myamount \#"$,0.00" }
You /may/ get the Access-style formatting if you change the way Word
connects to Access (check Word Tools|Options|General|"Confirm conversion at
open", re-connect and select the DDE option when offered) but I can't
remember off the top of my head.
You can also format data using VBA functions in an Access query and use that
query as the data source. You find that you need to do that if the column in
the Access database is defined as a currency type (as opposed to "double")
as Word sometimes seems to have difficulty working with that data type.
--
Peter Jamieson - Word MVP
Denis said:
I have documents that contain fields linked to an Access table (2002) but
for some reason the field property is not being included in the merge, i.e.
a field with CURRENCY is not displaying the $ nor the COMMA for numbers.
