Do you really need to display the $ in the field? Could you not put it on
the page before the text field?, then you wouldn't need to display the $ sign.
Alternately, you could replace the $ with nothing using Replace(fieldname,
"$", "")
Nick
At 15:18 18/05/00 -0700, you wrote:
>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.
