I woud like to place a toggle on my form that would cycle through "yes", "no" and null and record that response in a table. I would like the caption on the toggle to chenge to "yes", "no" or blank depending on the state of the button. I can't seem to get past the yes or no only in the table properties. I know this must be simple but I'm stuck. Thanks in advance for your help. Doug
yes/no/null toggle
- Thread starter Webster01
- Start date
mdemarte
Computer Wizard
- Local time
- Today, 20:04
- Joined
- May 8, 2001
- Messages
- 138
option group
Sounds like you have a Boolean field, which is probably what you needed initially for values of Yes or No. Now that you have a third value, Null, you should try an Option Group. Each option will have an integer value, then you need a lookup table 1 Y, 2 N, 3 Null in order to be able to store the value you want. The other solution is a one character text field.
Sounds like you have a Boolean field, which is probably what you needed initially for values of Yes or No. Now that you have a third value, Null, you should try an Option Group. Each option will have an integer value, then you need a lookup table 1 Y, 2 N, 3 Null in order to be able to store the value you want. The other solution is a one character text field.
Similar threads
