Yes, I saw that from John and Cetin replies to Colin. I will have to see about changing my code to that.

Thanks.

>Beth,
>
>You can just create a method and then do something like
>
>this.setall("DynamicBackColor", "thisform.myColorSettingMethod()", "Column")
>
>and myColorSettingMethod can be any regular code, for example a CASE structure, as long as it returns a valid color and it is fast :)