change Yes/No to Y only

[Harold Good]

Hi, I have textbox as part of my report, that depending if something is true
or false, displays Yes or No. Because the field is very narrow, all the
report shows is the first letters, either Y or N.

I would prefer to have it display "Y" when true, and blank when false. Is
it possible to do this? I've tried various formulas, with no success. I'd
prefer it as a formula, instead of VBA.

If a formula, what is the formula and where do I put the formula?

Thanks muchly,
Harold

 

[Jeff Boyce]

Harold

One approach would be to put something like the following in the Control
Source property of your report control (untested):

=IIF([YourYesNoFieldName]=True, "Y", "N")

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Harold Good]

Thanks Jeff, that worked perfectly! Since I didn't want the N to display, I
removed that from between the quotes and it works great.

Thanks so much,
Harold

Harold

One approach would be to put something like the following in the Control
Source property of your report control (untested):

=IIF([YourYesNoFieldName]=True, "Y", "N")

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi, I have textbox as part of my report, that depending if something is
true or false, displays Yes or No. Because the field is very narrow, all
the report shows is the first letters, either Y or N.

I would prefer to have it display "Y" when true, and blank when false.
Is it possible to do this? I've tried various formulas, with no success.
I'd prefer it as a formula, instead of VBA.

If a formula, what is the formula and where do I put the formula?

Thanks muchly,
Harold

 

[Jeff Boyce]

Thanks for posting back the results and the "wrinkle"... I bet someone else
will need (and find) that some day!

Jeff

Thanks Jeff, that worked perfectly! Since I didn't want the N to display,
I removed that from between the quotes and it works great.

Thanks so much,
Harold

Harold

One approach would be to put something like the following in the Control
Source property of your report control (untested):

=IIF([YourYesNoFieldName]=True, "Y", "N")

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi, I have textbox as part of my report, that depending if something is
true or false, displays Yes or No. Because the field is very narrow, all
the report shows is the first letters, either Y or N.

I would prefer to have it display "Y" when true, and blank when false.
Is it possible to do this? I've tried various formulas, with no
success. I'd prefer it as a formula, instead of VBA.

If a formula, what is the formula and where do I put the formula?

Thanks muchly,
Harold