tri value controls

[iccsi]

I am looking for controls on the form which data are 0,1,2 and would
like display like Yes, Undecide, No on the report.

Can you please advise which control is best to choose?


Your help is great appreciated,

 

[fredg]

I am looking for controls on the form which data are 0,1,2 and would
like display like Yes, Undecide, No on the report.

Can you please advise which control is best to choose?

Your help is great appreciated,

Use 1, 2, 3,

Use an Option Group control with 3 radio buttons with values set to
1, 2, and 3. Bind this Option Group to a Field in your table.

1 for Yes, 2 for Undecided and 3 for No.

In your report, add an unbound Text control.
Set it's control source to:
=Choose([OptionGroupName],"Yes","Undecided","No")

 

[Duane Hookom]

If you are stuck with storing 0,1,2 you can add 1 to get 1,2,3.
=Choose([OptionGroupName] + 1,"Yes","Undecided","No")
I normally recommend using a small lookup table with a field for the number
and another for the description.

--
Duane Hookom
Microsoft Access MVP

I am looking for controls on the form which data are 0,1,2 and would
like display like Yes, Undecide, No on the report.

Can you please advise which control is best to choose?

Your help is great appreciated,

Use 1, 2, 3,

Use an Option Group control with 3 radio buttons with values set to
1, 2, and 3. Bind this Option Group to a Field in your table.

1 for Yes, 2 for Undecided and 3 for No.

In your report, add an unbound Text control.
Set it's control source to:
=Choose([OptionGroupName],"Yes","Undecided","No")

 

[iccsi]

If you are stuck with storing 0,1,2 you can add 1 to get 1,2,3.
   =Choose([OptionGroupName] + 1,"Yes","Undecided","No")
I normally recommend using a small lookup table with a field for the number
and another for the description.

--
Duane Hookom
Microsoft Access MVP

Use 1, 2, 3,

Use an Option Group control with 3 radio buttons with values set to
1, 2, and 3. Bind this Option Group to a Field in your table.

1 for Yes, 2 for Undecided and 3 for No.

In your report, add an unbound Text control.
Set it's control source to:
=Choose([OptionGroupName],"Yes","Undecided","No")

- Show quoted text -

Thanks millions,