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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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")
 
Fred,

Thank you.

fredg said:
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
Click to expand...

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")
Click to expand...
 
Back
Top