Hiding text box until item checked

E

EHOWE

Hello

I am developing a form where there are 6 different items that on review will
pass or fail, if the area fails I would like a memo box to appear so they can
input a description on why it failed. I was using checkboxes, but it allows
the person to choose both pass and fail. I would like to use a combo box.
Any idea on how to code this so when they open the form the memo boxes are
hidden until fail is checked? Thanks for all of your help in advance
 
O

Ofer Cohen

On the After Update event of the check box you can write the code

Me.[MemoFieldName].Visible = Me.[CheckBoxName]

So if you click it, it will return True Or False and that way it will set
the memo field.

Also, Use this code on the OnCurrent event of the form if you are moving
between recrds
 
E

EHOWE

It worked perfectly
Thanks for the easy fix!!!

Ofer Cohen said:
On the After Update event of the check box you can write the code

Me.[MemoFieldName].Visible = Me.[CheckBoxName]

So if you click it, it will return True Or False and that way it will set
the memo field.

Also, Use this code on the OnCurrent event of the form if you are moving
between recrds

--
Good Luck
BS"D


EHOWE said:
Hello

I am developing a form where there are 6 different items that on review will
pass or fail, if the area fails I would like a memo box to appear so they can
input a description on why it failed. I was using checkboxes, but it allows
the person to choose both pass and fail. I would like to use a combo box.
Any idea on how to code this so when they open the form the memo boxes are
hidden until fail is checked? Thanks for all of your help in advance
Click to expand...
Click to expand...
 
Top