Re: Real Number Format Issue
Thanks for your inputs. Im testing to use a character field and filter it first and pass it to a real number field to limit the decimal places. Hopefully this will be a better approach for this problem. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Real Number Format Issue
Maybe so - my testing was typing directly on the form & getting the error on "Save". Anyway, I don't have much to help Allan - David > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC > Sent: Wednesday, November 07, 2012 11:16 AM > To: arslist@ARSLIST.ORG > Subject: Re: Real Number Format Issue > > Hmm...the scenario I was on was with Decimal fields, and numbers were > being entered into a console and being pushed from the console to the > parent form...maybe it was a weird combination at the time > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling > Sent: Wednesday, November 07, 2012 9:06 AM > To: arslist@ARSLIST.ORG > Subject: Re: Real Number Format Issue > > Huh, I don't know. I tried this just now on ARS 7.5 patch 007 & get an > error. I > get similar errors for decimal and integer fields, too. > > David > > > -Original Message- > > From: Action Request System discussion list(ARSList) > > [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC > > Sent: Wednesday, November 07, 2012 11:00 AM > > To: arslist@ARSLIST.ORG > > Subject: Re: Real Number Format Issue > > > > No, that's the weird thing...I had this requirement specifically when > > people where typing into the field, they just sometimes fat finger > > things and put special characters into the numeric fields and wanted > > me to throw errors when it happened. And, the weirdest thing is that > > the system throws NO errors when you do it, it simply considers the > > input invalid and truncates at the invalid error, so if you entered > > 123$5, everything past the $ gets truncated and your actual value in the > field is 123. > > > > -Original Message- > > From: Action Request System discussion list(ARSList) > > [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling > > Sent: Wednesday, November 07, 2012 8:56 AM > > To: arslist@ARSLIST.ORG > > Subject: Re: Real Number Format Issue > > > > Okay, thanks, I don't know if I've ever tried that - but then this > > must be for situations where someone's not directly typing into the > > real field, or they'd get the system-generated error, correct? > > > > David > > > > > -Original Message- > > > From: Action Request System discussion list(ARSList) > > > [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC > > > Sent: Wednesday, November 07, 2012 10:46 AM > > > To: arslist@ARSLIST.ORG > > > Subject: Re: Real Number Format Issue > > > > > > David, > > > The problem is that if you have a run-if firing on a qual of > > > something similar to > > > > > > 'Real Field' LIKE "%&%" > > > > > > And throw an error if true, you will find that the filter never > > > fires because the real field will actually truncate the data at the > > > & before it even hits the workflow. > > > > > __ > _ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 > www.wwrug12.com ARSList: "Where the Answers Are" > > __ > _ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 > www.wwrug12.com ARSList: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Real Number Format Issue
I use JavaScript too much, I know I do. But until AR System/MT comes with a better data validator system, I will use JavaScript regexp to validate/unvalidate. The idea is to add "onkeyup" listeners that call these functions. They check the current value for the field, and call an active link guide if it's valid, another if it's not. Now you can do pretty much any check you want. On Wed, Nov 7, 2012 at 5:06 PM, David Durling wrote: > Huh, I don't know. I tried this just now on ARS 7.5 patch 007 & get an > error. I get similar errors for decimal and integer fields, too. > > David > >> -Original Message- >> From: Action Request System discussion list(ARSList) >> [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC >> Sent: Wednesday, November 07, 2012 11:00 AM >> To: arslist@ARSLIST.ORG >> Subject: Re: Real Number Format Issue >> >> No, that's the weird thing...I had this requirement specifically when people >> where typing into the field, they just sometimes fat finger things and put >> special characters into the numeric fields and wanted me to throw errors >> when it happened. And, the weirdest thing is that the system throws NO >> errors when you do it, it simply considers the input invalid and truncates at >> the invalid error, so if you entered 123$5, everything past the $ gets >> truncated and your actual value in the field is 123. >> >> -Original Message- >> From: Action Request System discussion list(ARSList) >> [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling >> Sent: Wednesday, November 07, 2012 8:56 AM >> To: arslist@ARSLIST.ORG >> Subject: Re: Real Number Format Issue >> >> Okay, thanks, I don't know if I've ever tried that - but then this must be >> for >> situations where someone's not directly typing into the real field, or they'd >> get the system-generated error, correct? >> >> David >> >> > -Original Message----- >> > From: Action Request System discussion list(ARSList) >> > [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC >> > Sent: Wednesday, November 07, 2012 10:46 AM >> > To: arslist@ARSLIST.ORG >> > Subject: Re: Real Number Format Issue >> > >> > David, >> > The problem is that if you have a run-if firing on a qual of something >> > similar to >> > >> > 'Real Field' LIKE "%&%" >> > >> > And throw an error if true, you will find that the filter never fires >> > because the real field will actually truncate the data at the & before >> > it even hits the workflow. >> > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Real Number Format Issue
Hmm...the scenario I was on was with Decimal fields, and numbers were being entered into a console and being pushed from the console to the parent form...maybe it was a weird combination at the time -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Wednesday, November 07, 2012 9:06 AM To: arslist@ARSLIST.ORG Subject: Re: Real Number Format Issue Huh, I don't know. I tried this just now on ARS 7.5 patch 007 & get an error. I get similar errors for decimal and integer fields, too. David > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC > Sent: Wednesday, November 07, 2012 11:00 AM > To: arslist@ARSLIST.ORG > Subject: Re: Real Number Format Issue > > No, that's the weird thing...I had this requirement specifically when > people where typing into the field, they just sometimes fat finger > things and put special characters into the numeric fields and wanted > me to throw errors when it happened. And, the weirdest thing is that > the system throws NO errors when you do it, it simply considers the > input invalid and truncates at the invalid error, so if you entered > 123$5, everything past the $ gets truncated and your actual value in the > field is 123. > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling > Sent: Wednesday, November 07, 2012 8:56 AM > To: arslist@ARSLIST.ORG > Subject: Re: Real Number Format Issue > > Okay, thanks, I don't know if I've ever tried that - but then this > must be for situations where someone's not directly typing into the > real field, or they'd get the system-generated error, correct? > > David > > > -Original Message- > > From: Action Request System discussion list(ARSList) > > [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC > > Sent: Wednesday, November 07, 2012 10:46 AM > > To: arslist@ARSLIST.ORG > > Subject: Re: Real Number Format Issue > > > > David, > > The problem is that if you have a run-if firing on a qual of > > something similar to > > > > 'Real Field' LIKE "%&%" > > > > And throw an error if true, you will find that the filter never > > fires because the real field will actually truncate the data at the > > & before it even hits the workflow. > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Real Number Format Issue
Huh, I don't know. I tried this just now on ARS 7.5 patch 007 & get an error. I get similar errors for decimal and integer fields, too. David > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC > Sent: Wednesday, November 07, 2012 11:00 AM > To: arslist@ARSLIST.ORG > Subject: Re: Real Number Format Issue > > No, that's the weird thing...I had this requirement specifically when people > where typing into the field, they just sometimes fat finger things and put > special characters into the numeric fields and wanted me to throw errors > when it happened. And, the weirdest thing is that the system throws NO > errors when you do it, it simply considers the input invalid and truncates at > the invalid error, so if you entered 123$5, everything past the $ gets > truncated and your actual value in the field is 123. > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling > Sent: Wednesday, November 07, 2012 8:56 AM > To: arslist@ARSLIST.ORG > Subject: Re: Real Number Format Issue > > Okay, thanks, I don't know if I've ever tried that - but then this must be for > situations where someone's not directly typing into the real field, or they'd > get the system-generated error, correct? > > David > > > -Original Message- > > From: Action Request System discussion list(ARSList) > > [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC > > Sent: Wednesday, November 07, 2012 10:46 AM > > To: arslist@ARSLIST.ORG > > Subject: Re: Real Number Format Issue > > > > David, > > The problem is that if you have a run-if firing on a qual of something > > similar to > > > > 'Real Field' LIKE "%&%" > > > > And throw an error if true, you will find that the filter never fires > > because the real field will actually truncate the data at the & before > > it even hits the workflow. > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Real Number Format Issue
No, that's the weird thing...I had this requirement specifically when people where typing into the field, they just sometimes fat finger things and put special characters into the numeric fields and wanted me to throw errors when it happened. And, the weirdest thing is that the system throws NO errors when you do it, it simply considers the input invalid and truncates at the invalid error, so if you entered 123$5, everything past the $ gets truncated and your actual value in the field is 123. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Wednesday, November 07, 2012 8:56 AM To: arslist@ARSLIST.ORG Subject: Re: Real Number Format Issue Okay, thanks, I don't know if I've ever tried that - but then this must be for situations where someone's not directly typing into the real field, or they'd get the system-generated error, correct? David > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC > Sent: Wednesday, November 07, 2012 10:46 AM > To: arslist@ARSLIST.ORG > Subject: Re: Real Number Format Issue > > David, > The problem is that if you have a run-if firing on a qual of something > similar to > > 'Real Field' LIKE "%&%" > > And throw an error if true, you will find that the filter never fires > because the real field will actually truncate the data at the & before > it even hits the workflow. > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling > Sent: Wednesday, November 07, 2012 8:16 AM > To: arslist@ARSLIST.ORG > Subject: Re: Real Number Format Issue > > > -Original Message- > > From: Action Request System discussion list(ARSList) > > [mailto:arslist@ARSLIST.ORG] On Behalf Of Allan See > > Sent: Tuesday, November 06, 2012 8:35 PM > > To: arslist@ARSLIST.ORG > > Subject: Re: Real Number Format Issue > > > > Thank you for all the reply, > > > ... > > > > @David - there has been a couple of instances that users input > > special characters accidentally, and these values do not get > > filtered causing process to stop. i dont believe it is a process of export > > from databases. > > Alan, > > Sorry, guess I still don't understand, but at least Misi & LJ do. I > get "You have entered an improperly formatted value for a real field" > when I try to save with 123.2&5 in a real number field in the User Tool or > web. > > But rather than try to change the input, how about throwing an error > to the user telling them to correct it? Or does that have the same > problem with being unable to detect the incorrect characters on input? > > David > > David Durling > University of Georgia > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Real Number Format Issue
Okay, thanks, I don't know if I've ever tried that - but then this must be for situations where someone's not directly typing into the real field, or they'd get the system-generated error, correct? David > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC > Sent: Wednesday, November 07, 2012 10:46 AM > To: arslist@ARSLIST.ORG > Subject: Re: Real Number Format Issue > > David, > The problem is that if you have a run-if firing on a qual of something > similar to > > 'Real Field' LIKE "%&%" > > And throw an error if true, you will find that the filter never fires because > the > real field will actually truncate the data at the & before it even hits the > workflow. > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling > Sent: Wednesday, November 07, 2012 8:16 AM > To: arslist@ARSLIST.ORG > Subject: Re: Real Number Format Issue > > > -Original Message- > > From: Action Request System discussion list(ARSList) > > [mailto:arslist@ARSLIST.ORG] On Behalf Of Allan See > > Sent: Tuesday, November 06, 2012 8:35 PM > > To: arslist@ARSLIST.ORG > > Subject: Re: Real Number Format Issue > > > > Thank you for all the reply, > > > ... > > > > @David - there has been a couple of instances that users input special > > characters accidentally, and these values do not get filtered causing > > process to stop. i dont believe it is a process of export from databases. > > Alan, > > Sorry, guess I still don't understand, but at least Misi & LJ do. I get "You > have > entered an improperly formatted value for a real field" when I try to save > with 123.2&5 in a real number field in the User Tool or web. > > But rather than try to change the input, how about throwing an error to the > user telling them to correct it? Or does that have the same problem with > being unable to detect the incorrect characters on input? > > David > > David Durling > University of Georgia > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Real Number Format Issue
David, The problem is that if you have a run-if firing on a qual of something similar to 'Real Field' LIKE "%&%" And throw an error if true, you will find that the filter never fires because the real field will actually truncate the data at the & before it even hits the workflow. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Wednesday, November 07, 2012 8:16 AM To: arslist@ARSLIST.ORG Subject: Re: Real Number Format Issue > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Allan See > Sent: Tuesday, November 06, 2012 8:35 PM > To: arslist@ARSLIST.ORG > Subject: Re: Real Number Format Issue > > Thank you for all the reply, > ... > > @David - there has been a couple of instances that users input special > characters accidentally, and these values do not get filtered causing > process to stop. i dont believe it is a process of export from databases. Alan, Sorry, guess I still don't understand, but at least Misi & LJ do. I get "You have entered an improperly formatted value for a real field" when I try to save with 123.2&5 in a real number field in the User Tool or web. But rather than try to change the input, how about throwing an error to the user telling them to correct it? Or does that have the same problem with being unable to detect the incorrect characters on input? David David Durling University of Georgia ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Real Number Format Issue
> -Original Message- > From: David Durling > Sent: Wednesday, November 07, 2012 10:16 AM > To: arslist@ARSLIST.ORG > Subject: RE: Real Number Format Issue > > > > ... > > > > @David - there has been a couple of instances that users input special > > characters accidentally, and these values do not get filtered causing > > process to stop. i dont believe it is a process of export from databases. > > Alan, ( Sorry misspelled your name, Allan) > > Sorry, guess I still don't understand, but at least Misi & LJ do. I get "You > have > entered an improperly formatted value for a real field" when I try to save > with 123.2&5 in a real number field in the User Tool or web. > > But rather than try to change the input, how about throwing an error to the > user telling them to correct it? Or does that have the same problem with > being unable to detect the incorrect characters on input? > > David > > David Durling > University of Georgia ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Real Number Format Issue
> -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Allan See > Sent: Tuesday, November 06, 2012 8:35 PM > To: arslist@ARSLIST.ORG > Subject: Re: Real Number Format Issue > > Thank you for all the reply, > ... > > @David - there has been a couple of instances that users input special > characters accidentally, and these values do not get filtered causing process > to stop. i dont believe it is a process of export from databases. Alan, Sorry, guess I still don't understand, but at least Misi & LJ do. I get "You have entered an improperly formatted value for a real field" when I try to save with 123.2&5 in a real number field in the User Tool or web. But rather than try to change the input, how about throwing an error to the user telling them to correct it? Or does that have the same problem with being unable to detect the incorrect characters on input? David David Durling University of Georgia ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Real Number Format Issue
Thank you for all the reply, @Misi - The real field in trying to filter now was previously a char field, but user came to a conclusion to change the field to a real number field. i might go with one of your options the on gain focus for the real field, but users can have multiple entry on this said field so im having second thoughts on using that option. @David - there has been a couple of instances that users input special characters accidentally, and these values do not get filtered causing process to stop. i dont believe it is a process of export from databases. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Real Number Format Issue
Hi, just curious - under what conditions would one get numerical data that has special characters like that? Is that a function of exports from certain databases? David David Durling University of Georgia > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC > Sent: Tuesday, November 06, 2012 8:32 AM > To: arslist@ARSLIST.ORG > Subject: Re: Real Number Format Issue > > Allan, > As Misi described, I have also had this requirement, and had to use a Char > field to do the manipulation in question. > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Allan See > Sent: Monday, November 05, 2012 11:38 PM > To: arslist@ARSLIST.ORG > Subject: Real Number Format Issue > > Hi, > > I am trying to remove special character($,%,&, etc.) on a real number field. > So what happens is that when i input a value all characters after the special > character are turned to 0 > > here is an example: > 123.2&5 --> 123.200 > > what i wanted was the the '&' sign be removed but not replace the 5 with a 0. > 123.2&5 --> 123.205 > > is there a way we can filter this out for the real number field? or do you > have > any alternative to filter this? > > Thanks, > Allan > > __ > _ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 > www.wwrug12.com ARSList: "Where the Answers Are" > > __ > _ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 > www.wwrug12.com ARSList: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Real Number Format Issue
If your getting a "&" in your data, it sounds like you need to filter these out be fore loading them. If the original data is in a text format, any editor can do it. I use Notepad++ because its free and fairly powerful. You can also use a MERGE Filter on data load to filter out the special characters using the Replace function. If it's readying from another SQL Database, set up a view form and filter them using the Replace function when they come in (Submit or Modify). Gordon - Original Message - From: "Allan See" To: arslist@ARSLIST.ORG Sent: Tuesday, November 6, 2012 1:38:23 AM Subject: Real Number Format Issue Hi, I am trying to remove special character($,%,&, etc.) on a real number field. So what happens is that when i input a value all characters after the special character are turned to 0 here is an example: 123.2&5 --> 123.200 what i wanted was the the '&' sign be removed but not replace the 5 with a 0. 123.2&5 --> 123.205 is there a way we can filter this out for the real number field? or do you have any alternative to filter this? Thanks, Allan ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Real Number Format Issue
Allan, As Misi described, I have also had this requirement, and had to use a Char field to do the manipulation in question. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Allan See Sent: Monday, November 05, 2012 11:38 PM To: arslist@ARSLIST.ORG Subject: Real Number Format Issue Hi, I am trying to remove special character($,%,&, etc.) on a real number field. So what happens is that when i input a value all characters after the special character are turned to 0 here is an example: 123.2&5 --> 123.200 what i wanted was the the '&' sign be removed but not replace the 5 with a 0. 123.2&5 --> 123.205 is there a way we can filter this out for the real number field? or do you have any alternative to filter this? Thanks, Allan ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: Real Number Format Issue
Hi, The real-number-field is not accessible as a char-field, so you can not do this directly. Your best option might be to have the user enter the data in a char-field, and then do your filtering on that field instead. For example: On Gain Focus realField: Set-Fields: charField = $realField$ Change-Field: Hide realField Change-Field: Focus to charField, Show charField On Lose Focus charField: Set-Fields: do your magic on the charField Set-Fields: realField = $charField$ Change-Field: Hide charField Change-Field: Show realField But personally, I would try to avoid this altogether... Best Regards - Misi, RRR AB, http://rrr.se ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Real Number Format Issue
Hi, I am trying to remove special character($,%,&, etc.) on a real number field. So what happens is that when i input a value all characters after the special character are turned to 0 here is an example: 123.2&5 --> 123.200 what i wanted was the the '&' sign be removed but not replace the 5 with a 0. 123.2&5 --> 123.205 is there a way we can filter this out for the real number field? or do you have any alternative to filter this? Thanks, Allan ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"