~Brian
There are two other approaches to getting that many colors.
The old way using stacked text boxes and a solid block color
is a combination of the ideas at:
http://www.mvps.org/access/forms/frm0024.htm
http://www.mvps.org/access/forms/frm0055.htm
Since Conditional Formatting was introduced in A2K, another
way is to use four transparent text boxes using the solid
block font and with expressions to determine if CF should be
applied to the text box. The general idea is:
=IIf(status IN(1,2,3), "AAAA", Null)
=IIf(status IN(4,5,6), "AAAA", Null)
. . .
Then set the first text box's CF 3 conditions to:
[status] = 1 and ForeColor to the color for status 1
[status] = 2 and ForeColor to the color for status 2
[status] = 3 and ForeColor to the color for status 3
and the second text box:
[status] = 4 and ForeColor to the color for status 4
[status] = 5 and ForeColor to the color for status 5
[status] = 6 and ForeColor to the color for status 6
etc.
Note that because CF takes some time to perform all those
checks, it may be way better to set your existing text boxes
BackStyle to Transparent and put a single set of color text
boxes behind them (Format - Send to Back). You can size the
color text boxes to the entire detail section or any part.
--
Marsh
MVP [MS Access]