I have a form which has about 30 text boxes which I want to color code. So for the "forecolor" property I want to simply say something like "f_color(this.value)" instead of defining a specific color. the function f_color would do some calculation and would return a color such as red.

so thisform.text1.ForeColor= f_color(this.value) works well but i am getting a type error if the color returned is "50,50,50". if i do a VAL on the color as in thisform.text1.ForeColor= val(f_color(this.value)), it works but does not return the color i want. how, and in what format, do i return the correct color?

thanks,

Nancy