Joe, We are on ARS 7.1 and it is a custom app. The users enter the amount on a display form and the it does a push to another back end form. No error messages. If they enter $150.50 on the display form then 0.00 ends up on the back end form. Brian
________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Tuesday, August 11, 2009 1:03 PM To: arslist@ARSLIST.ORG Subject: Re: Decimal Field ** 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" <bso...@scholastic.com> To: arslist@ARSLIST.ORG 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 <http://www.scholastic.com/> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"