Customize Yes/no fields to "Normal/Abnormal"

[Guest]

I know there must be a simple way to have a yes/no check box that enters the
data as custom text such as "normal" / "abnormal". The issue comes up when I
report out the data and want "Normal" or "abnormal" to show up on the report
and not yes or no. any suggestions.

PN

 

[Van T. Dinh]

You can convert Yes/No (underneath they are -1 / 0) to Normal / Abnormal
either in the Query being used for the Report or in the Control on the
Report itself.

For example, you can define a calculated Field in your Query:

Norm_Abnorm: IIf([YesNoField], "Normal", "Abnormal")

You can use the same IIf expression in the Report.

And I am sure there are other methods as well.

 

[Guest]

In your query for the report put an IIF statement.

Your Field Label: IIF([YourField] = -1, "Normal", "Abnormal")

 

[JK]

Create a calculated field in the report and define the source as:

=IIf([YourCkBoxField]=True,"Normal","Abnormal)

Regards/JK

 

[Guest]

Put a text box on your report and set the control source property to
=IIf([CheckBoxName]=True,"Normal","Abnormal")

 

[Rick Brandt]

I know there must be a simple way to have a yes/no check box that
enters the data as custom text such as "normal" / "abnormal". The
issue comes up when I report out the data and want "Normal" or
"abnormal" to show up on the report and not yes or no. any
suggestions.

PN

Use a format property of...

;"abnormal";"normal"

....or...

;"normal";"abnormal"

....depending on which word you want for True. You can use that sort of
format property to substitute any two words in a Yesy/No field.