HELP! Change color of a control if criteria meets criteria in an unbound box

[Aileen]

Hi

Can anyone tell me of a quick way (preferably macro) to
change the background color of a control if it meets a
certain criteria?

 

[Steve Schapel]

Aileen,

If you want to do this with a macro, you would use the SetValue
action, in the Item argument you would put...
[NameOfYourControl].[BackColor]
.... in the Expression argument, enter the numerical code for the
color, and put your criteria expression in the Condition column of the
macro design.

However, if you are using Access 2000 or later, you may find the
Conditional Formatting a simpler solution. See under the Format menu
of the form design window.

- Steve Schapel, Microsoft Access MVP