teft field entry restriction
February 20, 2009 12:00 AM
Well, it's not pretty, but I did find a solution that works.I set an action on the submit button to modify a new variable. I called it EntryTest. I set it equal to Entry_0001. I then had another action that fires 0.2 seconds later (I am more comfortable with delays if I'm doing calculations to ensure the correct order is done). I modify EntryTest to divide by 1. I then changed the contents of a text box if the condition is true that Entry_0001 Is Equal To VAR(EntryTest). It looks like it works fine with numbers and does nothing for nonnumeric values. I did create an Else command that shows a warning message. It's fast and dirty, but it may do the trick. I don't know offhand of an IsNumeric function.Kevin
Discussions have been disabled for this post