CR XI - Shading/color if duplicated

[CRXIuser2005]

How do I color a field Both items...IF it is duplicated with the item above or below?

IF duplicated I would like to isolat those by shading or color.

Thx

Thank you.

MV

"A man is only as happy, as he makes up his mind to be....

 

[BobSuruncle]

Something like this for the background colour property:
If {YourTable.YourField} = Previous({YourTable.YourField})
then crYellow
else crNocolor

Bob Suruncle

 

[CRXIuser2005]

thanks

Thank you.

MV

"A man is only as happy, as he makes up his mind to be....

 

[lbass]

If you want both records colored, try:

If {YourTable.YourField} = Previous({YourTable.YourField}) or
{YourTable.YourField} = Next({YourTable.YourField})
then crYellow
else crNocolor

-LB

 

[CRXIuser2005]

I DO....thank you..

Thank you.

MV

"A man is only as happy, as he makes up his mind to be....