Dumb Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim McColl - 08 Dec 2005 17:35 GMT

Hi - I'm stuck on a simple problem I am trying to display a true/false field
in a report, and instead of the default value of a checkbox, I want to print
"Yes" or "No"

I have tried various permutations of : iif( [DBFld]=True,"Yes","No") .

So far no luck - keep getting syntax failures. Could some one please tell me
the correct format of the above.

Thanks

Reply to this Message

Steve - 08 Dec 2005 18:06 GMT

I don't necessarily know about displaying the Yes/No as "Yes" and "No"
without adding a checkbox to the form (unless you can just create a
textbox and make it point to your Yes/No field without a formula), but
I can give you a workaround.

Create a CheckBox with your Yes/No field (we'll say "chkYesNo"). Create
a TextBox (we'll say "txtBox"). For the textbox, use this formula:

IIf(Forms!frmMyForm![chkYesNo].Value=True, "Yes", "No")

You may also want to try using VB constants instead of True and False.
e.g. IIf(...].Value=vbYes, "Yes", "No")

I don't know for sure if the value in a Yes/No field will correlate to
vbYes and vbNo, but you can give it a shot.

Reply to this Message

John Welch - 08 Dec 2005 18:45 GMT

Steve's first answer was the best, I believe .. use a text box on your
report whose control source is your yes/no field. Set the format of the
textbox to "yes/no" and whala.

>I don't necessarily know about displaying the Yes/No as "Yes" and "No"
> without adding a checkbox to the form (unless you can just create a
> textbox and make it point to your Yes/No field without a formula), but
> I can give you a workaround.

Reply to this Message

Tim Marshall - 08 Dec 2005 19:50 GMT

> in a report, and instead of the default value of a checkbox, I want to print
> "Yes" or "No"
>
> I have tried various permutations of : iif( [DBFld]=True,"Yes","No") .

Try:

iif([DBFld]=-1,"Yes","No")

Signature

Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

Reply to this Message

Jim McColl - 17 Dec 2005 15:27 GMT

>> in a report, and instead of the default value of a checkbox, I want to
>> print "Yes" or "No"
[quoted text clipped - 4 lines]
>
> iif([DBFld]=-1,"Yes","No")

Tim - Sorry to be so lomg in responding. My question wasn't as dumb as I
thought. Your suggested solution works like a charm, and I can see why, but
I never would have figured it out and could not find any "help" references.

Thanks very much and thanks also to the others for responding. This is a
great newsgroup

Reply to this Message