By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 989 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

show different colors on a continous form

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.