[MS_AccessPros] Three state (Yes, No, blank) controls

 

Hi:

I am trying to replicate in an Access form a feature found in other
db software.

In other software, you can have a check box that has three possible
states: "Yes" or 1, "No" or 0, and blank. "Yes.shows as a check mark,
"No" shows as a blank white box, and blank shows as gray on the form.

The Access checkbox has two states: "Yes" or 1, "No" or 0.

We would like to do this to separate the "No" answers from the cases
where nothing was ever entered (blank, NULL, missing).

If I need to, I can do a combo box, but thought a check box format
would be faster and more elegant.

Any thoughts?

Thanks,
Gary

--------------------------------------------------------
Gary D. Schwartz Please reply to: gary.schwartz@pobox.com

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 15
• New Files 6

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___