Radio boxes and what they record

[Zorkmid]

I have a form that contains an 2 radio boxes for the user to specify whether a record is "resolved or unresolved". Currently this value comes out as a 1 or 2 in my table. Is there a way to record them as "Resolved" and "Unresolved". I have another form to edit existing records, and 1's and 2's in those two fields are difficult to understand.

Thanks

-Z

 

[Rabbie]

It is most efficient to store the values from radio buttons as integers. You can always display the results as "Resolved" "Unresolved" or what you want.

 

[Zorkmid]

How can I get that done?

-Z

 

[JANR]

In a query or report you can use a IIF statement to translate.

Status: IIF([field]=1,"Unresolved","Resolved")

I assume 1 is Unresolved if not switch Unresolved and resolved.

JR

 

[Zorkmid]

Thanks JANR,

I have decided to just include an option ground right in my search form now, seem simpler.

-Z