Hi, Nick!
What if RecordSource is SELECT - SQL statement? :)))
>Or, IIF(RECNO(this.RecordSource) = grno... so you are not hardcoding the alias.
>OR, (better yet :) download my Grid Highlighter class form Files Section/Classes-VCX file#
9798>
>:)
>
>>Use IIF(RECNO("MyAlias")....
>> This because correct alias may not be selected sometimes, so you need refer it directly.
>>
>>>Hi All! Hope someone can help me. Once in awhile I get an error that displays when my form is loaded. This form has a grid on it and I have logic to highlight the current record in the grid. The error is as follows: "Expression is invalid. Use a valid expression for DYNAMICBACKCOLOR property."
>>>
>>>This is the code I use to highlight the record:
>>>
>>>grno = RECNO()
>>>THISform.pageframe1.page1.grid1.setall("Dynamicbackcolor", ;
>>> "IIF(RECNO()=grno,RGB(128,192,192),RGB(255,255,255))","Column")
>>>
>>>Any suggestions? Thanks!
>>>
>>>Joe
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.