in list display only yes

[PowellGirlTN]

I have a report that is a list of all employees. I have a field for
"medicalNeeds". It is a yes or no entry in the table. I'm listing all
employees in the report but only want the yes to display for employees that
have medical needs..if the entry is now, I don't want it to display. How to
I set the properties to only show yes but still show all the records for all
the employees. Thank you for your help.

 

[fredg]

I have a report that is a list of all employees. I have a field for
"medicalNeeds". It is a yes or no entry in the table. I'm listing all
employees in the report but only want the yes to display for employees that
have medical needs..if the entry is now, I don't want it to display. How to
I set the properties to only show yes but still show all the records for all
the employees. Thank you for your help.

Is it a Yes/No check box field ?
Or a "Yes" "No" text field?

If it is a Check Box field, code the Format event of whatever section
in the report you are showing the Yes or No:

Me![ControlName].Visilble = Me![ControlName]

If it is a Text field, then:
Me![ControlName].Visible = Me![ControlName] = "Yes"

 

[PowellGirlTN]

Yikes, the source us a combo box...I can't get the code to work is that why,
does it need to be a text box? Thanks for the help and have a great day

I have a report that is a list of all employees. I have a field for
"medicalNeeds". It is a yes or no entry in the table. I'm listing all
employees in the report but only want the yes to display for employees that
have medical needs..if the entry is now, I don't want it to display. How to
I set the properties to only show yes but still show all the records for all
the employees. Thank you for your help.

Is it a Yes/No check box field ?
Or a "Yes" "No" text field?

If it is a Check Box field, code the Format event of whatever section
in the report you are showing the Yes or No:

Me![ControlName].Visilble = Me![ControlName]

If it is a Text field, then:
Me![ControlName].Visible = Me![ControlName] = "Yes"

 

[fredg]

Yikes, the source us a combo box...I can't get the code to work is that why,
does it need to be a text box? Thanks for the help and have a great day

I have a report that is a list of all employees. I have a field for
"medicalNeeds". It is a yes or no entry in the table. I'm listing all
employees in the report but only want the yes to display for employees that
have medical needs..if the entry is now, I don't want it to display. How to
I set the properties to only show yes but still show all the records for all
the employees. Thank you for your help.

Is it a Yes/No check box field ?
Or a "Yes" "No" text field?

If it is a Check Box field, code the Format event of whatever section
in the report you are showing the Yes or No:

Me![ControlName].Visilble = Me![ControlName]

If it is a Text field, then:
Me![ControlName].Visible = Me![ControlName] = "Yes"

If the control you wish to hide is a combo box, the code should be:
Me![ComboName].Visible = Me![ComboName] = "Yes"

However .......
Sometimes, with a combo box, what you see is NOT what you've got.
Please Copy and Paste into a reply message the actual Combo Box
Rowsource.
If it is a query or SQL statement copy and paste the actual SQL
statement.
Also what column is the Bound column of the combo box?