Hey everyone!
I had a look at some threads that were concerned over Boolean fileds (yes/no option/tick boxes or whatever? and thought i'd hopefully add something if it hasn't already been added.
there is an option where you could have three states if you select a tick box as your Boolean and in properites select "triple state". You can see that it takes another two clicks to bring it back to the tick tick (yes) state.
I personally find this way rather ambiguous.
Obviously changing the Boolean field to a text box and choosing the Yes/No option of field type within the tables will give you only two options. Yes or No.
I saw a couple of threads on if there was any way to have a null field to be the default rather than No (or yes)
So, I know this might be obvious to a lot of people but for some I'll explain how to.
* In the table. Use a normal text box to be your Yes/no field.
* Within the form, change your text box to a combo box
* within Properties in 'row source type' type No;Yes
* Type "" in the Default in properties
* choose Yes within 'Limit to List' and that's it.
that will give the Defualt of null. This helped me becuase I had code behind this control and a user had to select either the no or the yes for the code to run. Hope i've helped anyone.
regards.
I had a look at some threads that were concerned over Boolean fileds (yes/no option/tick boxes or whatever? and thought i'd hopefully add something if it hasn't already been added.
there is an option where you could have three states if you select a tick box as your Boolean and in properites select "triple state". You can see that it takes another two clicks to bring it back to the tick tick (yes) state.
I personally find this way rather ambiguous.
Obviously changing the Boolean field to a text box and choosing the Yes/No option of field type within the tables will give you only two options. Yes or No.
I saw a couple of threads on if there was any way to have a null field to be the default rather than No (or yes)
So, I know this might be obvious to a lot of people but for some I'll explain how to.
* In the table. Use a normal text box to be your Yes/no field.
* Within the form, change your text box to a combo box
* within Properties in 'row source type' type No;Yes
* Type "" in the Default in properties
* choose Yes within 'Limit to List' and that's it.
that will give the Defualt of null. This helped me becuase I had code behind this control and a user had to select either the no or the yes for the code to run. Hope i've helped anyone.
regards.
