>Text works fine if the data isn't dynamic. But when you change the logical value of the row, the altered text eventually propagates to all rows even though their underlying value has not changed. It appears that the IIF() isn't being evalutated at the row level but at the column level. Only the properties with "dynamic" in their name seem to be evaluated at the "cell" or row level. That's logical but not necessarily intuitive (hence the discussions in this thread <g>.)
>
>FWIW, most users really like the checkbox because it's easy and unambiguous, but there's a problem with legibility for the visually impaired. I use large fonts for textboxes but the checkbox comes in only one size. Color (DynamicBackColor or DynamicForeColor) is a big performance hit, mainly for 56K dailup users. Images are less of a aperformance drain but aren't much more legible than the checkbox.
Lynda,
I think you got me wrong. I wasn't talking about dynamic properties of the column. What I said is plain text control where no iif() evaluation needed at row level. iif() is only used in view while pulling the records off the base table.
Doing that with "dynamic" properties of column is rather tricky and FAQ entry about it might help (Conatiners in grid). However though I didn't try myself, I do not expect a good working result. I especially didn't think of "dynamic" since you said 'a large grid'. The more the rows it'd be slower.
Changing it with a graphical style one might be if you'd go with a checkbox.
If you just try once what I said maybe you'd be pleased with the result:)
Cetin