Image to appear on certain subform records

  • Thread starter Thread starter Hindsey
  • Start date Start date
H

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?
 
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, that works great, thanks for the tip -

Allen Browne said:
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.

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