Want report control only visible if...

[AccessNeophyte]

Hi All,

I'm self-teaching on Access as I develop a client tracking database
for my facility. I'm probably going to say this wrong, but here goes.

I have a report where I only want to have a particular field
(control?) visible if the data in the field it is boud to says a
specific thing.

The control is in the Detail section of the report, and it's called
Discharge Reason" It refers to a field with the same name in the
query the report is bound to. There are 8 possible entries for this
field, plus "Contract Change" That's the only one I want to see in my
report.

I only want to have the field "Discharge Reason" visible when the data
is "Contract Change"

Do I put this in the properties of the control? If so, where?

Thanks,
Access Neophyte

 

[Guest]

You'd better set the criteria in the query to "Contract Change" that way you
will get what you are asking for.