Can selecting a combo box makes a text box visible again

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
Is it possible when choosing a combo box to have it make a text box visible,
when in this text boxes properties you've chosen visible=NO. Can an event
procedure or some code be written that will make visible=YES.


Thanks any help with be greatly appreciated
 
On the after update event of the combo, you can write the code

Me.TextBoxName.Visible = (You condition)

Or
If (You condition) then
Me.TextBoxName.Visible = true
else
Me.TextBoxName.Visible = false
end if
 
Ofer said:
On the after update event of the combo, you can write the code

Me.TextBoxName.Visible = (You condition)

Or
If (You condition) then
Me.TextBoxName.Visible = true
else
Me.TextBoxName.Visible = false
end if
Click to expand...

I actually need to have the combo box make a total of 6 text boxes visible,
I got the 1 text box working but there are 5 more that I need to do the same
thing to. Is this possible through the combo box that got the 1 visible?
or can it be done in a daisy chain in the text boxes from one to the other?

Thanks-- For your help
 
I actually need to have the combo box make a total of 6 text boxes visible,
I got the 1 text box working but there are 5 more that I need to do the same
thing to. Is this possible through the combo box that got the 1 visible?
or can it be done in a daisy chain in the text boxes from one to the other?

Thanks-- For your help
 
Just use the same idea for the rest of the text boxes

Me.TextBoxName1.Visible = (You condition)
Me.TextBoxName2.Visible = (You condition)
Me.TextBoxName3.Visible = (You condition)
Me.TextBoxName4.Visible = (You condition)
Me.TextBoxName5.Visible = (You condition)
Or
If (You condition) then
Me.TextBoxName1.Visible = true
Me.TextBoxName2.Visible = true
Me.TextBoxName3.Visible = true
Me.TextBoxName4.Visible = true
Me.TextBoxName5.Visible = true
Me.TextBoxName6.Visible = true
else
Me.TextBoxName1.Visible = False
Me.TextBoxName2.Visible = False
Me.TextBoxName3.Visible = False
Me.TextBoxName4.Visible = False
Me.TextBoxName5.Visible = False
Me.TextBoxName6.Visible = False

end if
 
Thanks, gentleman You were allot of help,

I have another question, In my program I have the text boxes that show the
bid set for invisible, Then I have the combo boxes that populate these text
boxes have an on click event procedure that makes the text boxes visible.

Now when I close my program or if i filter to a new record the text boxes go
back to invisible. Is there any way to make my program show these text boxes
visible like they were before I exited the form, when I re-open it to the
same record?

Thanks Chuck
 
Ofer said:
Just use the same idea for the rest of the text boxes

Me.TextBoxName1.Visible = (You condition)
Me.TextBoxName2.Visible = (You condition)
Me.TextBoxName3.Visible = (You condition)
Me.TextBoxName4.Visible = (You condition)
Me.TextBoxName5.Visible = (You condition)
Or
If (You condition) then
Me.TextBoxName1.Visible = true
Me.TextBoxName2.Visible = true
Me.TextBoxName3.Visible = true
Me.TextBoxName4.Visible = true
Me.TextBoxName5.Visible = true
Me.TextBoxName6.Visible = true
else
Me.TextBoxName1.Visible = False
Me.TextBoxName2.Visible = False
Me.TextBoxName3.Visible = False
Me.TextBoxName4.Visible = False
Me.TextBoxName5.Visible = False
Me.TextBoxName6.Visible = False

end if
Click to expand...

I have another question, In my program I have the text boxes that show the
bid set for invisible, Then I have the combo boxes that populate these text
boxes have an on click event procedure that makes the text boxes visible.

Now when I close my program or if i filter to a new record the text boxes go
back to invisible. Is there any way to make my program show these text boxes
visible like they were before I exited the form, when I re-open it to the
same record?

Thanks Chuck
 
patentinv said:
Hi,
Is it possible when choosing a combo box to have it make a text box visible,
when in this text boxes properties you've chosen visible=NO. Can an event
procedure or some code be written that will make visible=YES.


Thanks any help with be greatly appreciated
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing text boxes based on combo selections 3
Combo Box to make visible 12
Field required only if visible 1
Text Box - Can't Make It Visible 7
combo box 1
Make a text box border color change with conditional formatting 12
Make Combo Box appear/disappear based on another combo box selecti 4
Make text boxes visible 1

Back
Top