General information
Category:
Forms & Form designer
Andrew,
You're entirely correct. Ultimately, I bet the customer will still want text with "Y" or "N" though!
>Hi Cindy,
>
>The check box can have a third state - greyed-out or unknown. If the control source is numeric, a value of 2 will put it in this state. If the control source is logical, a .null. will put it in that state. For yes/no answers, a check for isnull will tell whether the user has answered the question.
>
>Another alternative is to use an option group. Setting the initial value to 0 will mean that no answer is selected. You can ensure that the value of the control is >0 before allowing the user to leave the form.
>
>Cheers,
>
>Andrew
>
>
>
>>>>VFP 6.0 . I need to restrict the entry of a text box on a form to a "Y" or "N" entry. Is there an easy way to restrict the text box entry. The user must not be able to skip the field without a valid entry.
>>>>
>>>>TIA
>>>>
>>>>Rob
>>>
>>>Perhaps a checkbox? That's the proper control for a true/false.
>>
>>Craig,
>>
>>One of the problems with that (from my clinical trials days when everything was super picky) is that you can't tell the difference between a skipped answer and .F.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only