Yes / No function

[dcarr]

Hi. I have a table that I want to use the Yes/No option on a column. Instead of having Yes or No I want the table to display Smoker/Non-Smoker, what is the easiest way to go about this and configure the formatting so when viewed it displays "Smoker" or "Non-Smoker"? Thanks

 

[llkhoutx]

Use a combo box in your column, with the Yes/No field as the Control Source; then set the Row Source Type to Value List; and finally, set the Row Source to "-1;Smoker;0;Non-Smoker" (without the quotation marks.

 

[dcarr]

Thankyou this appears to have worked. Thanks for the contribution.

 

[Mile-O]

Why should it matter what's displayed in the table? As long as your form displays it then you're laughing.

 

[dcarr]

Hi, if I did have -1 for (Non-Smoker) and 0 - (Smoker) or vice-versa, how would I in the form get it to display yes or no? Also in the reports section of the DB I have created Membership cards that relate to the data in the table? How would I get these to display smoker/non smoker if the data in the table is made up of a series 0's and -1's? Thanks

 

[Mile-O]

Something along these lines:

=IIf([MyField] = -1, "Yes", "No")

 

[dcarr]

I'll give this a go now, thanks