[AccessD] Format dollar amount inside messagebox

David,

Try it like this...

"Amount will change from " & FormatCurrency(Me.txtOldAmt) & " to " & 
FormatCurrency(Me.txtIncentiveAmt)

Regards
Steve

-----Original Message----- 
From: David McAfee
Sent: Saturday, September 25, 2010 12:56 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Format dollar amount inside messagebox

I have this code:

If Me.txtOldAmt <> Me.txtIncentiveAmt Then 'Split & Amt Changed
                            strMsg = "Are you sure you want to change
this incentive?" & vbCrLf & _
                                     "Amount will change from " &
Me.txtOldAmt & " to " & Me.txtIncentiveAmt

It displays as: "Amount will change from 2 to 4.5"

I would like it to show as "Amount will change from $2.00 to $4.50"

Any idea?