[AccessD] Format dollar amount inside messagebox

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
> 





More information about the AccessD mailing list