Brian, That sounds like a strange one. What version of the ARS are you on? And is this happening on both the web as well as the native client? Since the Decimal field is not a character field it is not really possible to use any string functions against it to strip out any non numeric characters or spaces. You MAY be able to do it if you, set the value contained in the Decimal field, to a temp character field, and assuming it copies the whole value as the user enters it, you can strip the field of all Alpha characters and spaces, and then set it back to the Decimal field.. It still is strange that it doesn't throw an interface error like 'value out of range' or something but prefers converting a invalid value to a 0. Is this a custom developed application? Assuming that you are running the more recent versions of the ARS, you must be aware of the currency fields. If it is a custom application, have you tried using the currency field? Joe
________________________________ From: "Sokol, Brian" <[email protected]> To: [email protected] Sent: Monday, August 10, 2009 2:12:38 PM Subject: Decimal Field ** I have a form that is part of a purchasing application. The cost field on one of the forms is a decimal field. If a user enters a $ in front of the amount it is saved as 0.00. Any suggestions on preventing the users from entering a dollar sign? Thanks Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
