How to ignore space?

[daniel50096230]

Hi,I am using a textbox to validate ten rows data whether it is empty or having some data...But there is a problem,when the ten rows s empty,my textbox will still having all the space....For example, textbox1.text="..........."

How can I ignore the space?

 

[Andrew Poulsom]

This should give you the contents of the TextBox excluding spaces:

MsgBox Replace(TextBox1.Text, " ", "")

 

[daniel50096230]

How about if i want to use a string variable to store the textbox data without space???Because I had try many times.....

 

[Andrew Poulsom]

Like this?

Dim strVar As String
strVar = Replace(TextBox1.Text, " ", "")
MsgBox strVar