Need random colors for multiple text boxes on single form

[psandrew]

I have a form with 15 text boxes and want Access 2003 to randomly set a
different background color for each text box... Any ideas? Do I need some
code? Need to K.I.S.S. Thanx!

 

[psandrew]

This works fine, thank you, but I don't want any two or more text boxes to
ever have the same random color. Also would like to know how to use the RGB
function for the same situation, except that the text box color and shade
would be based on the text box value. For example, the values in the 15 text
bxs are 1 through 15. I want boxes with values 1 to 5 to be EACH a random
shade of blue, the boxes with values 6 to 10 to be ALL a random shade of red,
and boxes with values 11 to 15 to be EACH a random shade of any color. Your
help is most excellent. K.I.S.S for me please. Thanx.