what is the best way to format the yes/no option in forms? control (1 Viewer)

[martinr]

i have a boolean (yes/no) field that i need to have available for user selection in forms.
the preference is to display the chosen option as 'Yes' or 'No', rather than a check box (selected or deselected).
can te user change the option by just clicking on the form control (ie one click changes the option from Yes to No etc). so no data entry is needed, it's just a mouse click action that's required.

Is there a way to achieve this ?

 

[Ranman256]

the check box is simple since its either on or off.
if you use text, you must make 2 selections for option boxes.
create a frame, in the frame put the 2 options buttons....yes and no
set No option value = 0
set Yes option value = -1
bind the frame to the field. (its what gets the result of the options)

 

[isladogs]

I would also use a checkbox as it's by far the easiest for end users.
However if you want yes/no, I suggest using a combo box instead