Change the text box color on form load

[mikec]

I may be asking for more then I am ready for. I have a Continuos form in access, so basically a list. I have one field in the table that is ColorCode and the value is 1, 2, or 3 and on the form the textbox is named txtColor. So on FormLoad, I want access to change the color of that text box to a new color based off the value. Now I think this is how it would look for a standard form:



Private Sub Form_Load()

If txtColor.Value = "1" Then txtColor.BackColor = green

End Sub

But how can I do this for a continuos form

[pbaldy]

Take a look at Conditional Formatting on the ribbon. It would be your simplest solution.

[maximus]

conditional formatting was first introduced in Access 2000 and is probably the best and the easiest way you can solve yours problem. Open your form in design view Click on the control (TextBox) that you want to format, on the main menu bar now go to format and click on conditional formatting and add your criteria.

Please mark this thread solved if this solves your problem.