Change YesNo checkboxes to Yes/No or TrueFalse on a report

[Guest]

I have a report that has a YesNo checkbox. The users want me to change it so
that instead of the box with or without the check to have it state True or
False. It seems to me that I have seen how to change this somewhere but I
cannot find it.

tia

Vanya

 

[fredg]

I have a report that has a YesNo checkbox. The users want me to change it so
that instead of the box with or without the check to have it state True or
False. It seems to me that I have seen how to change this somewhere but I
cannot find it.

tia

Vanya

Place an unbound control where you want it.
Set it's control source to the Check Box field.

Set it's Format property to:
;"True";"False"

See Access help on
Format Property + Number and Currency datatype

or
you could set the control source of the unbound control to:
=IIf([CheckBoxField] = -1,"True","False")

 

[Guest]

Fred,

Thank you.

I have a report that has a YesNo checkbox. The users want me to change it so
that instead of the box with or without the check to have it state True or
False. It seems to me that I have seen how to change this somewhere but I
cannot find it.

tia

Vanya

Place an unbound control where you want it.
Set it's control source to the Check Box field.

Set it's Format property to:
;"True";"False"

See Access help on
Format Property + Number and Currency datatype

or
you could set the control source of the unbound control to:
=IIf([CheckBoxField] = -1,"True","False")