text box control source on report help 1

[kc112]

I have a field yes/no field for a test. Then I have combo boxes for all the possible outcomes if the test is positive.

On the report...I made a text box with:

=iif([cervical_extension]=true,"The patient demonstrated"&" "&[cervext1]&,& &" " &[cervext2]& "upon cervical extension.","")

Which works great. BUT...I need to be able to have the [cervext1] and [cervext2] be check boxes NOT comboboxes.

How do I write the control source so that [cervext1] is actually a checkbox values?

I tried:

=iif([cervical_extension]=true,"The patient demonstrated"&" "&(iif([leftsup]=true, "positive for left superior pain",""))& " " &"upon cervical extension.","")

but I get an error that I may have a comma without an operator.

Is it possible to embed a check box like I embedded a combo box in the text box control source?

Please and thank you!!!

Kristyn

 

[dhookom]

No. At least not that I am aware. You could use the Print method in code of the report to create this but I'm not sure you would want to go through the effort.

Have you considered using multiple controls rather than attempting to mix different fonts/symbols into one text box?

Duane
Hook'D on Access
MS Access MVP

 

[kc112]

What do you mean by using multiple controls?

Right now, I have 6 tests (cerv rot, cerv flex, etc...) for each of the 6 tests, there are 12 options (left sup, right sup, left inf., etc...)

So I set it up with the test field as yes/no checkbox and then 12 combo boxes for the possible outcomes (there could be 1 possible or 12).

Then on my report, I made a textbox referencing the check box with the above code (see previous post) that includes all 12 combo boxes. The only problem is, that this occurence is going to happen in several instances and it ends up with 6 fields/12 options each...thats 72!

I was hoping if I could use checkboxes then I could just make a grid with check boxes for the user to check. (72 checkboxes is smaller than 72 combo boxes).

The report has to be set up so that only the tests with positive outcomes print and it prints in the paragraph form combining all test results to one field. (i.e. "Patient demonstrated (12 combo box selections) upon (1 test check box selection)" (see previous post).

Any ideas? or am I stuck with 72 combo boxes (which i put on 6 different tabs).


thanks.

 

[dhookom]

IMO, your table structure is wrong. It isn't properly normalized. You might want to search the web on my name and "at your survey" to see how I would consider creating the tables.

Duane
Hook'D on Access
MS Access MVP

 

[kc112]

*ding * ding LIGHTBULB!! I get it! I was thinking horizontially for my fields, when I need to be thinking VERTICALLY!

Thanks for your insight!

Kristyn

 

[dhookom]

As a fellow-MVP John Vinson suggests "fields are expensive, records are cheap".

Duane
Hook'D on Access
MS Access MVP