Stuart McLachlan
stuart at lexacorp.com.pg
Fri Sep 24 20:03:54 CDT 2010
..."Amount will change from " & Format$(Me.txtOldAmt,"$0.00") & " to " & Format$(Me.txtIncentiveAmt,"$0.00")... On 24 Sep 2010 at 17:56, David McAfee 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 >