checking text box for empty value 1

[johnnyv]

Hi there
I have a textbox that contains a name, the user is allowed to change the name in the textbox then save it to a DB

I do not want to allow the user to save a empty value to the DB so how can I check to see if the textbox contains a value that is not blank. My concern is that if the user were to enter a value of
" "
is this different than a value of
" "
If so then a string compare will not work correct?

thanks

 

[zemp]

Try,

If Trim(Text1.Text)<>"" then...

Trim will remove any leading or trailing spaces.

zemp

 

[johnnyv]

Yup that will do it thanks zemp