>Has anyone used the DynamicCurrentControl property for a grid column successfully?
>
>I have set mine to:
> =IIF(.t., text1, spinner1)
>
>( I just plugged in .t., to prove that it wasn't my evaluation that was screwing it up. It made no difference.)
>
>I always get the spinner control.
>
>Am I missing something?


It works fine with just a slight modification. The line below is one I used to display alternating textboxes and comboboxes as the current control.
iif(int(recno()/2) = recno()/2, "text1","combo1")

Please not that there should NOT be an '=' sign in front of the IIF. The above line, or one like it is all that should appear in the property sheet. This means you cannot use the function option to write your property (or you can but be sure to remove the = sign afterwards). Some properties require the = sign and some don't. The trick is knowing when to use it and when not to. Since I can never remember, the only thing I do remember is if doesn't work with an equal sign, remove it, and if doesn't work without it, add it!

Bob