Changing colour of a field in a continuous form

  • Thread starter Thread starter acs68
  • Start date Start date
A

acs68

Hi all,

I have a continuous form that display rows of records. There is a field in
the form that is calculated for number of days. I want to change the colour
of that field if it is greater than 10 days (for example).

Could someone point me in the right direction as to how I would change the
colour for each record.

thanks in advance,

Adam
 
Hi all,

I have a continuous form that display rows of records. There is a field in
the form that is calculated for number of days. I want to change the colour
of that field if it is greater than 10 days (for example).

Could someone point me in the right direction as to how I would change the
colour for each record.

thanks in advance,

Adam
Click to expand...

If you are using Access 2000 or newer you can use the control's
Conditional Formatting property.

Click on the Control.
Select Format + Conditional Formatting
Set the Condition1 drop-down to
Field Value Is
Set the value to
Greater than 10

Set the colors as wanted.
Save the changes.
 
Thanks guys,

hadn't seen that one before. Works great.

Just wondering. Is it possible to do the same via code easily ? As some
categories will have different criteria based on the Category selected. i.e.
I am flagging items that have exceeded certain numbers of days. Some
categories will not need to be flagged so soon as they are not Urgent or
Critical.

any ideas?

cheers,

Adam
 
Back
Top