IF script issue
Good morning all:
This is such a basic script I am sure, but I have hit a wall and can't see the forest for the trees.
I have a text field from a related table on the form, and is limited to 4 characters. The first 3 characters are all variable letters, however the last letter is always either a U or Z. I am trying to write a script to run showing a Custom Dialog Box IF this field ends with the letter U and open a Dialog box with input fields. If the text field ends with the letter Z, script ends and move to next field.
I have tried every combination of wildcard operators, with no luck.
Any help with this fix, is greatly appreciated.