Search results

Thanks DBguy. It works fine without the gotfocus event, and it loads faster than the format conditions. For some reason the form flickers on and off if clicked on, but it's supposed to be for viewing only, so should be fine. Thanks again!

So if there are about 40 conditions that I'm trying to set to 5 controls, I'm going to get an error when the form loads, as its more than the 50 max? Or is it 50 for each control?

When setting format conditions manually you can highlight several controls and the condition will then say "multiple". is there a way of doing that with the code you wrote?

No, each text box has different RGB values, so one name can have 5 boxes next to it in different colors

I'm getting too many formatconditions because I'm trying to do so many for about 5 controls. How do I get to set to Multiple without putting it in for each control?

MajP, that worked perfectly. I modified it slightly to loop through several controls, as there can be several categories per student. Thanks for the help.

DBguy, I've got the RGB values in a table, I've also included them as part of the underlying query. How do I do it without conditional formatting? As I said earlier, the report is only showing the formatting in print preview.

I'll try explain what I'm trying to achieve. I have a student database. There are different categories that can be assigned to the student. Each category has a specific color that makes it easily recognisable to the staff. The student can also be linked to another student. On the student...

I created the report and put the code in the Detail Format event. It only works in print preview. How can i get it to work in layout view? Code I used: Me.T1.BackColor = RGB(Left([T1], InStr(1, [T1], ",") - 1), Mid([T1], InStr(1, [T1], ",") + 1, InStrRev([T1], ",") _ - (InStr(1, [T1], ",")...

Thanks strive4peace. It doesn't need to be edited. I've been trying with reports and subreports, but I'm getting the same results Can you help me with the coding?

I've been trying to set the conditinal formatting by code. I've got this so far: Dim FC As FormatCondition Me![T1].FormatConditions.Delete Set FC = Me![T1].FormatConditions.Add(acExpression, acEqual _ , "not isnull([T1])") FC.BackColor = RGB(Left(T1, 3), 0, 0) but its...

Hi, I'm trying to change the color of a textbox on a continous form. I need to color to change based on the RGB values in the text box. Is it possbile to do?