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
 

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

Similar Threads

Access 2010 0
help with code - newby 6
If yes, enter this text 3
Page visible when check box marked 2
make field invisable 4
Check Box query issue 3
Control visability of Label on a report 2
Stop blinking curser 2

Back
Top