change Yes/No to Y only

  • Thread starter Thread starter Harold Good
  • Start date Start date
H

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
 
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
 
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


Jeff Boyce said:
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 said:
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
Click to expand...
Click to expand...
 
Thanks for posting back the results and the "wrinkle"... I bet someone else
will need (and find) that some day!

Jeff

Harold Good said:
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


Jeff Boyce said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top