When field populates an image appears on Forms

[ctackett6407]

Greetings Folks,

I've been spending the past month learning Excel and Access and I'm learning more and more with practice

My question at the moment, which I cannot figure out, is I have a field on a report that can be either Y, N, or Blank.

I designed my form to look like an envelope and I'm wanting the envelope to show a rubber stamp saying "Pending" or "Received" .. but I cannot figure out how to get it to do it.

I figured out how to do it if it was a Y/N field. but the same options aren't available for Short Text.

Basically, I am trying to get it to show the "Received" stamp on the envelop when the field is a "Y" and if it is anything else.. it shows the "Pending."

Is that even possible?

 

[welshgasman]

If you know how to do it for a Y/N control, the method should be the same?
Instead of

If YNField Then

you would use

If txtField = "Y" then

or am I missing something obvious here?