Customise Continuous forms

[Rebecca]

I have a continuous form displaying data of records with
expiry dates. I want to be able to automatically colour
the records that have expired Red, and the ones about to
expire black. Problem is when you set a control to
automatically calculate this information it sets all
records to be the same colour in the continuous form

 

[Marshall Barton]

I have a continuous form displaying data of records with
expiry dates. I want to be able to automatically colour
the records that have expired Red, and the ones about to
expire black. Problem is when you set a control to
automatically calculate this information it sets all
records to be the same colour in the continuous form

You can not use VBA to set the properties of a control on a
continuous form without having all rows show the same thing.

In A2k and later you can use Conditional Formatting (Format
menu) to set the condition and several property settings to
get what you want.

In A97 and earlier, it a little tricky.