Visible Question

[Bob Vance]

Trying to make my list box visible if there is data in my text box, List box
set to No/Visible
If tbClient(Text Box) has data in it then lstClients.Visible = True

 

[sandro]

Trying to make my list box visible if there is data in my text box, List
box set to No/Visible
If tbClient(Text Box) has data in it then lstClients.Visible = True

 

[Dirk Goldgar]

Trying to make my list box visible if there is data in my text box, List
box set to No/Visible
If tbClient(Text Box) has data in it then lstClients.Visible = True

What have you tried?

"tbClient(Text Box) has data in it" is equivalent to "Len(Me.tbClient &
vbNullString) > 0". A concise way of expressing what you want is:

Me.lstClients.Visible = (Len(Me.tbClient & vbNullString) > 0)

You are probablygoing to have to execute that statement in the form's
Current event and in the AfterUpdate event of tbClient.