Will there ever be a cost of 0.00? If not, then couldn't you trap that and assume that the user put in the $, and tell them that they are bad, and to rekey the entry?
Darrell Reading Systems Engineer Phone 479.204.5739 [email protected] Wal-Mart Stores, Inc. 805 Moberly Lane, MS-0560-68 Bentonville, AR 72716 Save Money. Live Better ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Sokol, Brian Sent: Tuesday, September 01, 2009 10:16 To: [email protected] Subject: Re: Decimal Field ** Hi Joanne, How do I use a mask for this field? It is a decimal field that gets pushed to the same form with an AL. I guess pushing this field content does not throw an error but only pushes 0.00. So if a user enters $150.00 the value ends up 0.00. Anyone have an idea how to prevent this? I put this large note on the form but our staff seems to not read it. You would think we would have good readers at a publishing company :) IMPORTANT Please enter only numbers in the cost field. DO NOT ADD A DOLLAR SIGN ($). Thanks, Brian ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Mansur, Joanne Sent: Tuesday, August 11, 2009 1:24 PM To: [email protected] Subject: Re: Decimal Field ** My suggestion would be to put the $ outside the form at the left edge - customers would be less likely to add a $ if there was already one there. But you could also use a mask to be sure that all values entered are either numeric or a decimal point. Hope this helps, Joanne Mansur Client Systems Analyst Northeastern University (617) 373-3295 (office) (617) 373-5985 (fax) [email protected] From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Sokol, Brian Sent: Monday, August 10, 2009 2:13 PM To: [email protected] Subject: [ARSLIST] 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: [email protected] ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ ----------------------------------------- ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately. ********************************************************************** Wal-Mart Confidential ********************************************************************** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
