>>Hi,
>>
>>I have a grid where the first column is a text box, and the other columns are editboxes. I want the backcolor of the editbox to be different if the controlSource (a memo field in a cursor) is not empty. I have the following to achieve that:
>>
>>
>>FOR EACH loCol IN .COLUMNS
>>WITH loCol
>> .FONTSIZE = 8
>> .Header1.FONTBOLD = .T.
>>
>> IF .COLUMNORDER = 1
>> .Text1.DISABLEDFORECOLOR = .Text1.FORECOLOR
>> ELSE
>> .SPARSE = .F.
>>
>>** set all appts to have yellow backcolor
>> .DYNAMICBACKCOLOR="IIF("+loCol.CONTROLSOURCE+"='',RGB(255,255,255),RGB(255,255,128))"
>> ENDIF
>>ENDWITH
>>
>>
>>It works fine UNTIL I make the column/editbox Read-only - then the editbox always has a backColor of white.
>>
>>To help zero in on the problem, I changed one of the columns that had an editbox to be a textbox, and the color for THAT column apprears properly, i.e., looks like DynamicBackColor works properly for columns w/read only text boxes, but not read only edit boxes.
>>
>>Any help/insight to this problem? TIA. J
>
>Jill,
>When RO it gets color from disabledback/forecolor. Do not set to readonly but control RO indirectly with KeyPress. ie:
>
>if nKeyCode>31
>nodefault
>endif
>
>Cetin
Ahhhh, that explains it...rr-eat Cetin, thanks! j