Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

if then statement on checkbox to print text on report?

Status
Not open for further replies.

kc112

Technical User
May 16, 2011
41
US
Hello,

I have had much help with this forum..so here we go again!

I have a yes/no field titled "Froment's Paper Sign." If the patient is negtive for the test, then do not print and do not check box. If patient is positive for the test, I want the user to 'check' the check box and on the report, I want it to output, "The patient showed positive for Froment's Paper Sign."

I am sure this is a simple code, but I have no training on access, code, or VBA language. I am thinking something like...

Private Sub Froments_Paper_Sign_Click()
if "o", do not print
else true = "The patient..."
End Sub

But I know I am missing a lot!

Can anyone help me out with the code here?

Thanks!!
Kristyn


form: handexam
field: Froments paper sign
report: treatmentplandata
 
I think I got it...

The form dislays a checkbox.

On my report, I placed a text box with a control source stating:

=IIf([froments_paper_sign]=True,"The patient showed positive for the Froment's Paper Sign indicating a possible ulnar nerve paralysis.","")

works great!

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top