I'm not sure how to get the record number. I'm using visual basic 6.0, I have a SQL statement/object in vb data environment which is bound to the crystal report that I'm doing. I understand how to change the colors but not on how to get the record number. Should I maybe put any alias in the sql statement to count and then based on that number do the color change that I want to do?