The previously suggested code should work. Of course you would use the backcolor property instead since text that isn't there doesn't have a color (What is the sound of one hand clapping Grasshopper?) The fact that it isn't makes me wonder which event your putting the code in, and if it's being fired at all?
>>Did you put the IIF under the regular color property or "Dynamic" color property. This will be under the column, not the actual textbox in the column. And you might want to change it to reflect the source..
>>
>>Ex:( For Grid1.Column1 )
>>Thisform.Grid1.Column1.DynamicForeColor = "iif( empty( MyTable.WhatField ),RGB(100,100,100),RGB(255,255,255))"
>>
>>Hope this helps.
>
>I did both, acutually. I started out with what you have there, and when that didn't work, I tried putting it in th backcolor property of the combobox itself. No luck there, either.
>
>Thanks,
>
>-Michelle
kenweber
GCom2 Solutions
Microsoft Certified Professional