Trying to lock a listbox IF another textbox value has IS BLANK

Hi All,

I am tying to lock a listbox (ufrmSession.lstlookup) based on if a textbox (ufrmSession.txtlookup) is blank. The below works if i don't click into the textbox (ufrmSession.txtlookup) but if i type in space, space etc it seems to recognize as if there is something in it!

I don't wont that to happen. Any ideas? (Please find below the code i am using)

Please Login or Register  to view this content.

Hi,

Try changing the following line:

Please Login or Register  to view this content.

The Trim() function will remove leading and trailing spaces (and multiple spaces) from a string.

Lewis

thank you that's great!