report text box format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

edhead - 26 Oct 2005 18:43 GMT

I have a text box in a report where the control source is field that
contains either a 1 or a 0. I am trying to setup the format of the text
box to display Fail for a 0 value and Pass for a 1 value but I can't
figure out the syntax for the format. Thanks in advance for any help!

Reply to this Message

Marshall Barton - 26 Oct 2005 19:27 GMT

>I have a text box in a report where the control source is field that
>contains either a 1 or a 0. I am trying to setup the format of the text
>box to display Fail for a 0 value and Pass for a 1 value but I can't
>figure out the syntax for the format. Thanks in advance for any help!

Try this in the text box's Format property:

"Pass";"Fail";"Zero";"Null"

Signature

Marsh
MVP [MS Access]

Reply to this Message

fredg - 26 Oct 2005 19:30 GMT

> I have a text box in a report where the control source is field that
> contains either a 1 or a 0. I am trying to setup the format of the text
> box to display Fail for a 0 value and Pass for a 1 value but I can't
> figure out the syntax for the format. Thanks in advance for any help!

Use an unbound control instead.
Set it's Control Source to:
=IIf([FieldName] = 1,"Pass","Fail")

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message