Conditional Reporting

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

Guest

Hi everyon

I would like to show a text box's comments if another text box states Yes. Sort of like conditional formattiing. Hope I explained this clearly

Thanks To Al
kw_uh97
 
Use an expression in the ControlSource, e.g.:
=IIf([YourOtherBox], "He says Yes", Null)

Make sure the Name property of this text box is not the same as the Name of
your field. You will confuse Access if you change the ControlSource, but
leave the Name the same as the field.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

kw_uh97 said:
I would like to show a text box's comments if another text box states Yes.
Click to expand...
Sort of like conditional formattiing. Hope I explained this clearly.
 
Allen, thanks so much for mentioning the condition that the Name property could not be the same as the field. I have been troubleshooting my conditional reporting problem for an hour before I came here and began searching through the posts for one similar to my issue. The problem was the Name property all along!
 
Excellent! Good snooping.

You are certainly not the first to be caught with that one.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Dorci said:
Allen, thanks so much for mentioning the condition that the Name property
Click to expand...
could not be the same as the field. I have been troubleshooting my
conditional reporting problem for an hour before I came here and began
searching through the posts for one similar to my issue. The problem was
the Name property all along!
 
Back
Top