use colored icons (or fonts) in place of text in a lookup table

  • Thread starter Thread starter heik09
  • Start date Start date
H

heik09

I'm developing a table in Access 2007, and want to add a lookup column to
flag records as red, yellow, or green...depending on how close they should be
watched. It's such a simple function in Outlook...to add flags and color them
based on type. Is this possible in Access?
 
Sure you can, just not in tables.

Create a continuous form, and use Conditional Formatting to set a textbox's
colour according to the value of the field in question.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Thanks! This works, though I wish there were a way to format the font style.
I thought if I used wingdings, then I could display a flag in different
colors, depending on the degree of compliance. Like I said...it's used in
Outlook, so why not add the functionality in Access?
 
I had actually replied to this 16.5 hours ago, but for some reason, it has
failed to appear here, so I'm reposting it.

Well you can, but you have to add a textbox whose font is set to Wingdings
and whose Caption property is set to O (the flag symbol). Then in
Conditional Formatting, add criteria for the colours you want based on the
value of another control.

If Forms!MyFormName!SomeControl BETWEEN 3 AND 5 (set the colour to red,
for example)
....and so on.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Back
Top