Display Radio Button Value on Report

[ecklers]

Hi All-

I have a form that tracks gender values, by a radio button group.

By virtue of the wizard, these will assign either a value of 1 or 2 in
the option group.

Does anyone know how I can take the option value, to display in a
checkbox field on a report if the individual is male or female?

Thanks for your help in advance.

Nate

 

[Marshall Barton]

I have a form that tracks gender values, by a radio button group.

By virtue of the wizard, these will assign either a value of 1 or 2 in
the option group.

Does anyone know how I can take the option value, to display in a
checkbox field on a report if the individual is male or female?

A report text box can use an expression to do that:

=IIf([the field] = 1, "Male", "Female")

Or, if you want the report to also use an option group, then
just bind the report's option frame control to the same
field as the form's option frame.

 

[ecklers]

Thanks for your help- but how would I get this to enable a checkbox
value?

 

[Marshall Barton]

Thanks for your help- but how would I get this to enable a checkbox
value?

For a Check box, use the expression

=([the field] = 1)