I would use a regular expression to remove *all* non-numeric characters. Then, check to see if the remainder is numeric. You could do this both on the client and the server.
M!ke -----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, March 06, 2006 7:16 PM To: CF-Talk Subject: RE: Ok, I give...how can I do this... Thanks for the tip, Josh...yet another way I'll have to validate an entry. Maybe it's just easier to let them make an illegal entry, then tell them how I want them to enter the data than try to catch all the possible violations... I wonder what will happen if they enter $1,000 and I run it against IsNumeric(Replace(Form.Dollars, ",","","all")) ? What about that dollar sign? I'll have to see...thanks, Josh... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234421 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
