T
tkaplan
i have an excel form that i want that after the user enters data, whe
he tries to exit text box it validates the data for him and if it'
valid the background changes to white.
i currently have the colors changing if there is any data in the txtbo
at all. i would like it to be that it needs to have two names in th
field - the director's first and last name. so i want it to check th
the first word is more than one letter, followed by a space, and the
at least two more letters.
i am putting the code in the txtDirector_Exit event.
i know the changing color code, i need to code to check the data in th
box.
thanks in advance
tkapla
he tries to exit text box it validates the data for him and if it'
valid the background changes to white.
i currently have the colors changing if there is any data in the txtbo
at all. i would like it to be that it needs to have two names in th
field - the director's first and last name. so i want it to check th
the first word is more than one letter, followed by a space, and the
at least two more letters.
i am putting the code in the txtDirector_Exit event.
i know the changing color code, i need to code to check the data in th
box.
thanks in advance
tkapla