Sending to Word Bookmarks

[Kenln]

I have a Word doc (template) that I populate from an Access Form

I use

   With Wrd.ActiveDocument.Bookmarks
      .Item("Name").Range.Text = Me.txt_Name.Value
      .Item("Address_1").Range.Text = Me.txt_Address_1.Value
      .Item("Rate").Range.Text = Me.txt_Rate.Value      
   End With

Except!!!

The rate value is a number which should be displayed as $1,000.00. Currently it only displays as 1000 which they wont' accept.

I tried using Form Bookmarks but when I lock the doc for a form it won't populate, if I don't lock it, it replaces the existing bookmark with 1000.

Any help would really be appreciated.

Thank you,

 

[boblarson]

Have you tried using:

.Item("Rate").Range.Text = Format(Me.txt_Rate.Value, "Currency")

 

[Kenln]

I owe you again.

Actually I have never used the 'Format' command.

Thanks again,

If you're ever in So Fla I owe you a beer/soda.