I have a continuous form. One text box is called "Status" and has six possible choices. I'd like to color the background of the Status text box based on the status. For example, if status is "On Hold" the background of the Status text box should be red. How do I get beyond the limit of 3 conditions?

You can go into VBA and set the back ground color there, based on the selection.

ex:

Private Sub status_AfterUpdate()

if me.status = "On Hold" then
me.txtStatus.backcolor = vbRed
.....etc...

The simple answer is "You can't." Conditional formatting is limited to 4 ... The default and the 3 conditions.

You will need to use something like this.

So I saw the referenced thread, interesting technique. However, I'm having trouble with the z-order. When I place the colored text boxes on the Status text box, it covers it up. If I place Status on the colored boxes the color is there but again the Status is hidden. How do I put the Status box on top?

Related question: can I set the Back Color property for the Status text box using a function? In other words, instead of a number in the Back Color box (e.g., -2147483643), have it point to a function that calculates the color based on the value of the text box?

You cannot control this via code because of it being a continuous form. When you change the backcolor, it will change it for all the records.

It would be best if you just posted a stripped copy of the DB with a detailed explanation of the coloring you need and I'll take a look.

Attached is a much simplified version. Basically, for each status I'd like a unique color to be displayed on the form. Thanks in advance!

Do you mind reposting it in ACC2000 format? Either that or I"ll have to wait till I get home to open it with 2003. Thanks!

Attached...

See attached...

What do the Û's represent in the text box? And did you do anything special to get the Status to remain on top?

=IIf([Status]=4,"ÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛ","")

Those are Full Block characters in the Terminal font.

To get Status on top of them all I selected the Status field, placed it on top of all the other boxes, and chose "Format> Bring to Front" off of the menus.

(IMG:http://www.utteraccess.com/forum/style_emoticons/default/thumbup.gif) Works like a champ! For some reason I was looking in the properties box and right-click menus for that. Thanks for all your help!

I have been using this code for a while now. Not to bring this out of the grave, but is there any way that you could subsitute the Û for something else. What I really wish to accomplish is to allow a printer friendly version of the code. When I look in the print preview it looks beautiful, but as I print you can still see all of the Û's.

Thanks in advance.

Printer drivers can wreak havoc on higher Character Set values.

The only thing I could recommend is trying a different font and finding another Full Block character. You would then just change the font formatting of the control to match.

You can use the system Character Map to explore new fonts.

Start> All Programs> Accessories> System Tools> Character Map

...and hope your printer driver does not thrash the new one.

Awesome. Worked like a charm. I just found a full block character that actually looks like a block.

Thanks for the very prompt reply.

-Brad

NP. (IMG:http://www.utteraccess.com/forum/style_emoticons/default/thumbup.gif)

You may consider sharing the font you used so that others who are having the same issue can benefit. (IMG:http://www.utteraccess.com/forum/style_emoticons/default/wink.gif)

I had the same issue as Bradley110, when it came to printing reports that use this technique. I went to the Character Map (Start> All Programs> Accessories> System Tools> Character Map), checked the Advanced View box, and then searched for Full Block.

On my machine, the only resulting character is called U+2588 Full Block and it looks like a solid, upright, black rectangle.

I copied this from the Character Map and pasted it in place of the Û and the print output looks like the screen output. WYSIWYG.

Thanks Walter, for such a slick workaround to the conditional formatting limitation!

Mark

I know this is a pretty old thread, but I was wondering if anyone knew how to change the conditions. For example, the attached files have conditions such as



How do I change it so that it searches for a string such as



Thanks!