*** THIS IS A REPOST SINCE I POSTED IN THE WRONG FORUM ***
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.
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?