>>>>>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.
Maybe so, Tavaritsch, but who's to say that the grid is only disabled when the form's in edit mode. It may be disabled for some other reason :-)
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.