Simplest Yes/No value list?

[K1200]

I'm using the Format As Boolean option for a numeric flag value, with the displayed values being simply "Yes" and "No".

I defined a value list so the user can make their Yes/No selection. Currently, the options that are shown to the user are "1 = Yes" and "0 = No" -- and everything works fine.

However, I would like to offer simple "Yes" or "No" choices. Is there a way to define the value list to display only the words but still set the numeric field without having to define a table to hold the choices?

Thanks for any help.

[comment]

I don't think so. I just make the field a button that toggles the choice.

[K1200]

Thanks for the suggestion.

I tried it using a Case statment to toggle the value, but upon clicking the field (to toggle it) the field displays a 0 or 1 until I click somewhere outside of the field. Then it displays the appropriate "Yes" or "No". Have I missed something? Or is that how it has to work?

[comment]

If the field itself is a button, that shouldn't happen.

See the demo I have posted here.

[K1200]

Thanks. That did it.

I had overcomplicated things by using an Insert Calculated Result. The simpler Set Field + "not" operation does the job.