General information
Category:
Forms & Form designer
>THIS.SetAll("DynamicBackColor",;
"IIF(MOD(RECNO( ), 2)=0,RGB(255,255,0),RGB(255,255,255))","Column")
That works great for toggling colors in a grid if the table is in physical record order, but if the table is indexed prior to instantiating the grid, the results are quite cumbersome
Heres my work around (this.afterrowcolchange) for highlighting the active row in an indexed table
if thisform.pnCurRecord <> recno('tablename')
this.Setall("DynamicBackColor", ;
"IIF(recno('tablename')<>(thisform.pnCurRecord),RGB(255,255,255),RGB(0,255,255))","Column")
thisform.pnCurRecord = recno('tablename')
endif
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only