Image to appear on certain subform records

[Hindsey]

I have a form with a subform. I would like a small image to appear on records
of the subform that meet a certain criteria. Is this possible? ...Let me
rephrase, I'm sure it is, but what would be the best way to do it?

 

[Allen Browne]

The simplest way to do this would be to use a text box bound to an
expression that returns True for the condition when you want to show the
graphic, or False when you don't. Set the font to Wingdings (or similar),
and it will then show the graphic character.

The expression in the Control Source would be something like this:
=IIf([Credit] > [Debit], True, False)

 

[Hindsey]

Allen, that works great, thanks for the tip -

The simplest way to do this would be to use a text box bound to an
expression that returns True for the condition when you want to show the
graphic, or False when you don't. Set the font to Wingdings (or similar),
and it will then show the graphic character.

The expression in the Control Source would be something like this:
=IIf([Credit] > [Debit], True, False)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have a form with a subform. I would like a small image to appear on
records
of the subform that meet a certain criteria. Is this possible? ...Let me
rephrase, I'm sure it is, but what would be the best way to do it?