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

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.

--
HTH
Van T. Dinh
MVP (Access)



"P Nahser" <(E-Mail Removed)> wrote in message
news:450C0484-6512-4D78-BA5C-(E-Mail Removed)...
>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

In your query for the report put an IIF statement.

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


"P Nahser" wrote:

> 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

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

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

Regards/JK


"P Nahser" <(E-Mail Removed)> wrote in message
news:450C0484-6512-4D78-BA5C-(E-Mail Removed)...
>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

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

"P Nahser" wrote:

> 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

P Nahser wrote:
> 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.


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com