In the results of a query - or in just displaying records in a table - what
is the best way to display certain records in different colors.
EXAMPLE - a Company has been in business over 50 years - through the years -
they bought out other companies. - additionally they have a few different
branches.
OK - each record shows the source of the original business - 6 in total. -
We want all comapny "A" to display in red - all company "B" to display in
blue. - all company "C" to be green - and so on.
Does this have to be in VB Code under General Declarations..... or is there
a better way. -
If it is VB,  is a a set font color statement - is it attached to the query
or to the table?????
Thanx to all

What version of Access are you using? If Access 2000, look in help for
Conditional Formatting.  If it's Access 97, there's a sample for this at
www.lebans.com.

  -- Dev

: In the results of a query - or in just displaying records in a table -
what
: is the best way to display certain records in different colors.
: EXAMPLE - a Company has been in business over 50 years - through the
years -
: they bought out other companies. - additionally they have a few different
: branches.
: OK - each record shows the source of the original business - 6 in total. -
: We want all comapny "A" to display in red - all company "B" to display in
: blue. - all company "C" to be green - and so on.
: Does this have to be in VB Code under General Declarations..... or is
there
: a better way. -
: If it is VB,  is a a set font color statement - is it attached to the
query
: or to the table?????
: Thanx to all
:
: