use #DollarFormat(Rate)# and dont try to insert
"$" sign with it, cause it puts that for you.
----- Original Message -----
From: "Cyrill Vatomsky" <[EMAIL PROTECTED]>
To: "Cf-Talk@Houseoffusion. Com" <[EMAIL PROTECTED]>
Sent: Thursday, May 18, 2000 6:18 PM
Subject: Pesky dollar format
> Hi, All
>
> I am working with MS Access DB that has a currency datatype field. I
> retrieve the data into the form:
> <cfinput type="Text"
> name="Rate"
> value=#NumberFormat(Rate, "$999999.99")#>
>
> It displays fine with the "$" where it is supposed to be, but when I
submit
> the form (without editing), I get the SQL error complaining that I am
trying
> to update a numerci column with a value '$300'. Somehow it is not a number
> anymore.
>
>
> Is there a way to convert the $300 back into whatever MS Access will take
> for currency field?
>
> Cyrill
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
