By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,504 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

Yes/No Control

P: 69
Using ACCESS '97

Hi there, am wondering if there is a way to have a YES/NO field in a table have a NULL value. At the same time have the NULL value be the default.

You see, I have a drop down field in a table and the end-user has the option of selecting either YES or NO. I would like to have this drop-down start off with a BLANK field and require the end-user to select either YES or NO.

Thank you in advance for your time and assistance with this.

K_Escherich
Jul 19 '07 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
Using ACCESS '97

Hi there, am wondering if there is a way to have a YES/NO field in a table have a NULL value. At the same time have the NULL value be the default.

You see, I have a drop down field in a table and the end-user has the option of selecting either YES or NO. I would like to have this drop-down start off with a BLANK field and require the end-user to select either YES or NO.

Thank you in advance for your time and assistance with this.

K_Escherich
If you are using a value list then try setting it as follows:

"";"Yes";"No"
Jul 30 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.