show different colors on a continous form

[JK]

Hi All,
I am working a form which is tabular layout (continuous form) which
will display multiple records at a time. Each line of record needs to
be reflected on the color code to show their current status. In
Access 2000, you can only write the code on each control in a general
way and the code will apply on to the current record. For instance,
if you have 5 customers in display, each one of them has difference
balance, if you like to show a color for the line if the balance is
between the range of the dollar amount, and different color for
different dollar amount. How can you control the color display on
each individual record??
Please advise! Thanks.

JK

[Stig]

Try Conditional Formatting

The Conditional Formatting dialog box is available by clicking
Conditional Formatting on the Format menu when a form is in Design
view.

You can even put an unbound (empty) field in your form not showing any
value, and let the background colour change depending on the value of
the balance.
This will effect the colour of each record displayed in your continous
form.

The Condition Type must in your case be "Expression". Type in an
expession using the fieldnames from your form. ([txtBalance] > 10000)

(Conditional Formatting was introduced i Access 2000)

Stig
sr******@earthlink.net (JK) wrote in message news:<99**************************@posting.google. com>...

Hi All,
I am working a form which is tabular layout (continuous form) which
will display multiple records at a time. Each line of record needs to
be reflected on the color code to show their current status. In
Access 2000, you can only write the code on each control in a general
way and the code will apply on to the current record. For instance,
if you have 5 customers in display, each one of them has difference
balance, if you like to show a color for the line if the balance is
between the range of the dollar amount, and different color for
different dollar amount. How can you control the color display on
each individual record??
Please advise! Thanks.

JK

[David Neagle]

sr******@earthlink.net (JK) wrote in message news:<99**************************@posting.google. com>...

Hi All,
I am working a form which is tabular layout (continuous form) which
will display multiple records at a time. Each line of record needs to
be reflected on the color code to show their current status. In
Access 2000, you can only write the code on each control in a general
way and the code will apply on to the current record. For instance,
if you have 5 customers in display, each one of them has difference
balance, if you like to show a color for the line if the balance is
between the range of the dollar amount, and different color for
different dollar amount. How can you control the color display on
each individual record??
Please advise! Thanks.

JK

Have a look at the Microsoft Knowledge Base.

http://support.microsoft.com/default...&Product=acc97