How to make some fields visible/enabled only after checkbox (Yes/No value) is checked

[Leaden]

I would imagine that I will have to use codes, but not entirely sure how I would do this.

Also, is it fine to use yes/no fields? or is it better to just have combo box with 1 and 2 to meet yes/no?

 

[pbaldy]

Does this help?

http://www.baldyweb.com/ConditionalVisibility.htm

 

[Leaden]

hmm do i still use True and False for checkbox?

 

[pbaldy]

In the If statement? Yes, or -1 and 0.

 

[Leaden]

Thank you!
Also, can I make it disabled, rather than invisible?

 

[pbaldy]

Sure, you can affect any property of the control.

 

[Leaden]

How would I make them disabled? Also, Where am I putting those codes? Sorry I am kinda new to all these...

 

[pbaldy]

You can look at the properties window of a textbox to see all the properties of it. For enabled

Me.Textbox.Enabled = True/False

Code goes here:

http://www.baldyweb.com/FirstVBA.htm

 

[Leaden]

I put the code and modified the code (for names), so it would look like this,

Private Sub TUGUnable_Click()

If Me.TUGUnable = "True" Then
Me.TUGTrial1.Visible = False
Else
Me.TUGTrial1.Visible = True
End If


End Sub

However, it does not make TUGTrial1 visible or invisible when I click on checkbox.
Am I missing something?

 

[pbaldy]

I would probably use the after update event of the checkbox, though click might work. You don't want quotes:

If Me.TUGUnable = True Then

 

[Leaden]

NICEEEEEEEEEEEEEEE Thank you! It worked!

 

[pbaldy]

Happy to help!