Nope, I took out the WITH This and explicity put This. in front of everything and it still gave me the message.
Thanks for trying, though.
Dana
>I added some more text to my message, after you read it. When the DynamicBackColor expression is evaluated, it does not see the "With this" since it is not valid anymore.
>
>>I would think that it should not be an issue, since the code is within the
>>
>>WITH This
>>...
>>ENDWITH
>>
>> structure, but I'll check that out.
>>
>>Dana
>>>>WITH This
>>>> .Tag = STR(RECNO('vSbvPromoDestinations'))
>>>>
>>>> .SetAll("DynamicBackColor", "IIF(RECNO('vSbvPromoDestinations') = VAL(ALLTRIM(.Tag)), ;
>>>> RGB(255,255,128), RGB(255,255,255))", "Column")
>>>>
>>>> .Refresh()
>>>>*.colAirportCode.DynamicBackColor = RGB(0,128,255)
>>>>ENDWITH
>>>>
>>>>
>>>>Please help, it's driving me nuts!
>>>>
>>>>Thanks,
>>>>Dana
>>>
>>>My guess is the missing "this"
>>>WITH This
>>> .Tag = STR(RECNO('vSbvPromoDestinations'))
>>>
>>> .SetAll("DynamicBackColor", "IIF(RECNO('vSbvPromoDestinations') = VAL(ALLTRIM(this.Tag)), ;
>>> RGB(255,255,128), RGB(255,255,255))", "Column")
>>>
>>> .Refresh()
>>>*.colAirportCode.DynamicBackColor = RGB(0,128,255)
>>>ENDWITH
Where's the damned Any Key?...too late