>>>>I have a grid bound to a table. Each record in the grid has a unique ID named no_in_row i.e. 10, 20, 30. I want to change the background colour on the row to grey or red for example but only if the no_in_row=110 when in disabled mode. Is this possible?
>>>
>>>Neil
>>>
>>>Further to Aaron's soln., I guess you could also squeeze a "and thisform.Grid1.enabled = .F." into the IIF()
>>>
>>>Terry
>>
>>Better to use form's property, such as thisform.lEditMode
>
>Maybe but cos the form's in or out of edit mode, doesn't mean the grid will be disabled/enabled. Besides, the .SetAll() usually goes in the form's .Init() doesn't it. Thus it only needs test the grid's .enabled status in the one place.
DynamicBackColor evaluates dynamically <g>, so it would reflect current status of thisform.lEditMode. Setting lEditMode to false automatically sets all form controls into appropriate enable/disable state.
If it's not broken, fix it until it is.
My Blog