 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / July 2005YES OR NO VALIDATION RULE
In Access 2003, I am simply trying to create a few fields in which the only data that can be entered into the field is "yes" or "no". I am hoping to do this through my database field properties. (bound). For example, an employee needs to know if there is signage at a job site, a Yes in that field can then be later used to create a report of all the yes answers, so he can go to those jobsites and pick up the signs.(Obviously, am new to Access). Thank you for your help and patience. June27 > In Access 2003, I am simply trying to create a few fields in which > the only data that can be entered into the field is "yes" or "no". I [quoted text clipped - 5 lines] > patience. > June27 Any reason you don't just use the Yes/No DataType?  SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com I am not familiar with the Yes/no data type. Can you direct me? > > In Access 2003, I am simply trying to create a few fields in which > > the only data that can be entered into the field is "yes" or "no". I [quoted text clipped - 7 lines] > > Any reason you don't just use the Yes/No DataType? > I am not familiar with the Yes/no data type. Can you direct me? In Table design view select a field and look at the choices offered for the data type. Yes/No is one of them. It stores -1 for True (Yes) and 0 for False (No). It is often displayed as a CheckBox in forms, but on reports it can be formatted to show "True/False", "Yes/No", etc.. SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com You can have it to display more by using an Iif statement -- Iif([YourYesNoField]= -1,"Signs on-site", "Pick up signs for site") > > I am not familiar with the Yes/no data type. Can you direct me? > > In Table design view select a field and look at the choices offered for the data > type. Yes/No is one of them. It stores -1 for True (Yes) and 0 for False (No). > It is often displayed as a CheckBox in forms, but on reports it can be formatted > to show "True/False", "Yes/No", etc.. > You can have it to display more by using an Iif statement -- > Iif([YourYesNoField]= -1,"Signs on-site", "Pick up signs for site") No need for that. The format property can be used for any two text outputs. For your example one would use a format of... ;"Pick up signs for site";"Signs on-site" SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com Thanks for the info.,works like a charm. Table did display checkboxes as you said it probably would so I also formatted my forms with (bound) checkboxes. Very helpful post, thanks again. June > > You can have it to display more by using an Iif statement -- > > Iif([YourYesNoField]= -1,"Signs on-site", "Pick up signs for site") [quoted text clipped - 3 lines] > > ;"Pick up signs for site";"Signs on-site" |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.