Convert Checkbox to text

[allredkj]

Can you assist me in converting a checkbox to text? I need to do it two ways:
1. Checkbox on = X; Checkbox off = (null)
2. Checkbox on = Yes; Checkbox off = No

Thankx a ton!

Kelly

 

[John Big Booty]

I'm not sure I follow with exactly what it is you are trying to do Could explain a little further what it is you want to do. A check box will only ever show as checked or unchecked.

 

[bob fitz]

I assume you are talking about displaying boolean data on a bound form.

1. Checkbox on = X; Checkbox off = (null)

This can be done by just using a check box control and setting its Contro Source property to the name of the field in the table/query.

2. Checkbox on = Yes; Checkbox off = No

Create a text box and set its Control Source property to:
=IIf([NameOfYourBooleanField]=-1,"Yes","No")