merge to word

[lisa]

In merging a word doc with my database, the field
containing a dollar amount populates the word doc field
in a fixed format. The database design: filed= number,
format long integer, currancy, auto decimalplace. Please
advise. When I look at in form view and spreadsheet view,
both are correct "$100.00".

 

[John Nurick]

Hi Lisa,

One way round this is to create a query in your database that uses a
calculated field to explicitly format the numbers, and then merge from
this query. The calculate field will look like this:
fAmount: Format([Amount], "$#,##0.00")

 

[lisa]

thanks guys, i'll try both

-----Original Message-----
Don't know if you got an answer yet, but I would try

going to the TABLE and checking the format of the field
there. Sounds like you checked the Form properties, but
did you check the table properties? Another suggestion,
instead of the Auto decimal place, choose 2.