[AccessD] Format dollar amount inside messagebox

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
>




More information about the AccessD mailing list