468,110 Members | 1,797 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,110 developers. It's quick & easy.

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
Nov 12 '05 #1
2 4894
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

Nov 12 '05 #2
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
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by DS | last post: by
reply views Thread by gavo | last post: by
reply views Thread by ReidarT | last post: by
2 posts views Thread by access baby | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.