Hiding text box until item checked

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

Guest

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
 
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
 
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
 

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

Back
Top