Text Box Y or N Only

  • Thread starter Thread starter Günther Schmitt
  • Start date Start date
G

Günther Schmitt

hello and thanks for helping me.

I have a Text box in my form for Data Input to my table.

In on textbox i need only Yes or No. How do i do that? Thanks
Guenther Schmitt
 
If the textbox is bound to a field in the table, and the field in the
table is only meant to be true or false - nothing else - then the
better approach, would be this:

- change the field in the table, to a Boolean field;

- change the control on the form, to a checkbox.

A Boolean field can only be True or False. A checkbox can only be
checked (ticked) (True), or unchecked (blank) (False). That's what
Boolean fields, and checkboxes, are for - simple true/false, yes/no
choices.

HTH,
TC (MVP Access)
http://tc2.atspace.com
 
Thanks was very helpful but i still have a problem. I am using not a check
box. i am using a combo box, linked to a YES NO Table . When i scroll down
my combo box in the form , i can select YES or No, but it shows -1 or 0. In
the table it shows Yes or no. I use this form for Customers Input to my
table.

MY Q: Why do i see a 0 or -1 in my Combo Box in the Form after i select YES
or NO and how can i change that?

I am originally from Germany so please excuse my bad English and thanks
again for helping me

Guenther Schmitt
 
Back
Top