Visible Question

  • Thread starter Thread starter Bob Vance
  • Start date Start date
B

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
 
Bob Vance said:
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
Click to expand...
 
Bob Vance said:
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
Click to expand...

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.
 
Back
Top