Formula help

  • Thread starter Thread starter Chad
  • Start date Start date
C

Chad

I have a check box on my form and when I bring up my report I want to have a
text box display inactive if the check box was checked and dont dispaly
anything if it wasnt checked like visable=false..How would I do this? Thanks!
 
Chad

Is this checkbox bound to an underlying field? In other words, does the
database/table "remember", or is the form's checkbox only for appearance?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Chad

Provided the form is still open so the report can "see" it, you could add
code to the reports Format event that sets the visible property of that
textbox. It would look something like:

Me!txtMyTextBox.Visible = Forms!YourFormName!chkYourCheckBoxName

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top