Customise Continuous forms

  • Thread starter Thread starter Rebecca
  • Start date Start date
R

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
 
Rebecca said:
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
Click to expand...


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.
 
Back
Top