Yes/No Formatting for Text Box on a Report

[bmdumr]

I'm trying to set up the format in a text box on a report. If I put i
a text box with data [bob] which is a yes/no data type, I can give i
the custom formatting I wish in the format property as: ;"WAS";"WA
NOT"

Now how do I go about formatting a text box control where I want t
include some other text (using the format$() command)? Here was m
idea, which does not work:

Textbox data:
="Preceeding text " & Format$([bob],";was;was not") & " ending text"

This gives me an error and so does double quoting the 'was' and 'wa
not'. In fact when I use the above, it changes it t
Format$([bob],";w\as;w\asn""ot"""). What gives?

Any ideas? I know this has to be possible, I just can't get i
though.

Thanks,
Brad
(e-mail address removed)

 

[Al]

I'm trying to set up the format in a text box on a report. If I put in
a text box with data [bob] which is a yes/no data type, I can give it
the custom formatting I wish in the format property as: ;"WAS";"WAS
NOT"

Now how do I go about formatting a text box control where I want to
include some other text (using the format$() command)? Here was my
idea, which does not work:

Textbox data:
="Preceeding text " & Format$([bob],";was;was not") & " ending text"

This gives me an error and so does double quoting the 'was' and 'was
not'. In fact when I use the above, it changes it to
Format$([bob],";w\as;w\asn""ot"""). What gives?

Any ideas? I know this has to be possible, I just can't get it
though.

Thanks,
Brad
(e-mail address removed)

One way:

="Preceding text WAS " & IIf([bobl]=True,"","NOT") & " ending text."

Please note that there is a space after WAS and a space before ending
within the quotes.

HTH
Al
email addy is not valid