Does substr have to be used in the calculate event? I have all my script in the exit event.

substr appears to be a Formcalc method only - not JavaScript. Your suggestion stopped the error but it does not appear to be doing what i expected. Are you sure it can alos be used in JavaScript?

Unfortunately, with the lower case "s" I am still getting the substr undefined error.

I have a script that "walks" through all the records in an Access database table to find the largest file ID number. This script has been working correctly. Now I need to add a prefix to all the ID numbers. This requires me to modify my script so it ignores the one character prefix (prefix is either...

Thank you again - I appreciate your help.

I see now what I was doing wrong. Thank you - much appreciated!One other question, to script is not null, is this correct (again for a dropdown in exit event...if(this.rawValue !=null){//do something}or should it be !==null (with two == signs instead of one?)

I have a script that runs when the form user exits a dropdown object after making a selection. I do not want the script to run if the dropdown object is left blank (user does not make a selection). I need to create an if statement to test if the user made a selection from the dropdown. All the items...

As far as I can tell, your script solved my problem.Thank you so very much for your help!

My form has some items added to a ListBox by the form user.I need a script that will loop through the ListBox list, find and delete any items that display as blank (can click in that row but no text is displayed).

Thank you for your help with this.