Validating a Decimal Field

Avatar

Avatar

RoC1909

Avatar

RoC1909

RoC1909

26-04-2011

*** THIS IS A REPOST SINCE I POSTED IN THE WRONG FORUM ***

Hello,

I have a quick question and I hope someone can help me.

I  have a form that contains a table with approximately 10 columns and 20   rows. For two of these columns, the rows (AKA fields) within it are   decimal fields w/ 2 leading and 2 trailing digits. I would like these   fields to ONLY allow a user to enter a number from 1 to 24.(or be left  empty so the range might be 0 to 24), and  if a user attempts to place a  number outside of this range, a validation  message pops up stating so.

I am sure it's easy to do, so if someone can point me in the right direction, I would appreciate it.

Thank you.

View Entire Topic

Avatar

Avatar

RoC1909

Avatar

RoC1909

RoC1909

26-04-2011

Hey Paul,

I hate opening this thread again since you resolved my issue, but I didn't want to create another "new" thread and crowd the forum.

I noticed one thing, if a person were to click in the cell, and then decide against entering anything, as if they chose the wrong cell, the script still fires off (obviously due to having the script as the EXIT event for the field) and I get the "enter a value 1 to 24" message. Is there any way that I can overcome this with a slight modification to this script so that if a person were to click a cell by accident, and then click out of it without entering anything, the message wouldn't pop up?

Thanks again for all of your help.