[AccessD] Format dollar amount inside messagebox

David,

Couldnt you simply change

"Amount will change from " &
Me.txtOldAmt & " to " & Me.txtIncentiveAmt

To

"Amount will change from $" &
Me.txtOldAmt & " to $" & Me.txtIncentiveAmt


Paul

On 25 September 2010 01:56, David McAfee <davidmcafee at gmail.com> wrote:

> 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?
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Paul Hartland
paul.hartland at googlemail.com