Using a Check Box to make a Text Visible/Invisible

[Sideburns]

I am trying to use a checkbox to make a textbox visible when checkbox=yes and invisible when the checkbox=no. I am not sure if this is the best way to go about this. It has been a while since I have used access and need some refreshing. All help is appreciated

[Rabbit]

You can use the on click or after update event to set the textbox's visible property.

[cgrider]

I am trying to use a checkbox to make a textbox visible when checkbox=yes and invisible when the checkbox=no. I am not sure if this is the best way to go about this. It has been a while since I have used access and need some refreshing. All help is appreciated

the easiest way to do this would create some code for the after update event.

sub chkbox_afterupdate()
 
if me.checkbox then
 me.textbox.visible= true
else 
me.textbox.visible=false
end if
 
end sub
 

hope this helps

CG

[Sideburns]

Should this code go in the textbox after update or the checkbox? Thanks for your help.

[missinglinq]

The checkbox AfterUpdate.

[Sideburns]

Got it, works great. Thanks for the help.