David McAfee
davidmcafee at gmail.com
Fri Sep 24 20:07:50 CDT 2010
Awesome, thanks! On Fri, Sep 24, 2010 at 6:03 PM, Stuart McLachlan <stuart at lexacorp.com.pg> wrote: > ..."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 >> > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >