Display Radio Button Value on Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ecklers@gmail.com - 12 Dec 2005 21:55 GMT

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

Reply to this Message

Marshall Barton - 12 Dec 2005 22:34 GMT

>I have a form that tracks gender values, by a radio button group.
>
[quoted text clipped - 3 lines]
>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.

Signature

Marsh
MVP [MS Access]

Reply to this Message

ecklers@gmail.com - 12 Dec 2005 22:44 GMT

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

Reply to this Message

Marshall Barton - 12 Dec 2005 23:47 GMT

>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)

Signature

Marsh
MVP [MS Access]

Reply to this Message