300,000 records is way too many to display in a grid. You should do a SQL SELECT or view for the required records and ORDER BY the desired sort order. That way, you'll only have the records you want and you can color by record number.

>I have a grid that is fed by a potentially large table (up to 300,000 records and fairly wide). Depending on which radio button is clicked, the table indexes in different ways (last name, account number, first name, date of birth, etc.). How do I get the rows to alternate colors (odd rows color A, even rows color B)? Setting them by record number doesn't work because the table can be indexed several ways. Also, sometimes the grid will contain only some of the records (for example, records of people with certain initials). Anything that involves scanning the records is too slow. Any ideas?
>
>Jerry