Dear All,

Using Cetin's idea on dynamicBackcolor, I want to display the information in a grid where 2 backcolor alternated each other, such like single recno or double recno... however, this time is using the date, the records with same date using same backcolor...

IN dynamicbackcolor of the grid

Thisform.pf1.tx.SetAll("dynamicbackcolor","IIF(MOD(thisform.getbackcolor(ptt1.tx_date,'ptt1'),2)=0,RGB(212,237,218),RGB(255,255,255))", "Column")

Custom Method: getbackcolor

LPARAMETERS tdate, cTable

DO CASE
CASE cTable = 'ptt1'
	SELECT RECNO('tmpvisit1') as a FROM tmpVisit1 INTO CURSOR tmp WHERE tx_date = tdate
CASE cTable = 'ptt2'
	SELECT RECNO('tmpvisit2') as a FROM tmpVisit2 INTO CURSOR tmp WHERE tx_date = tdate
ENDCASE

RETURN tmp.a

tmpVisit1 is generated from the ptt1 as follows:

SELECT distinct tx_date from ptt1 into cursor tmpVisit1 order by tx_date

However, the backcolor is changing according to tx_date?! what's wrong? Please help