>
>I don't see where I 'slammed' you. I just tried to point on weak place in your code. Surely, I can be wrong here, and probably your code doesn't have weaknesses. However, if you have a problem and ask a question this indicates that your code really has problems. You see, some kind of contradictions...
>I don't know what is your app about, but I see some alarming points. You said that you you check 240 columns, and there are some natural questions:
>1. Is it necessary to bring all 240 columns into the same grid?
>2. How useful it for users to scroll through 240 columns?
>etc...
>I completely agree, that you must not answer these questions, but the core problem here that sometimes a thread instead of discussing specific programming problems going to general issue of product quality, and sometimes it's disappointed a little bit.


My application is a scheduling application. The grid actually represents a calendar used to schedule jobs for production in different plants. Each column represents a day and each line represents a set of jobs scheduled in a specific plant. A plant can have multiple jobs scheduled on the same day, so each plant will have multiple lines in the grid.

Each plant also has non-production days. In the table which is the recordsource for the grid, non production days are set to the value "Blackout" and are displayed as "blacked out", (ie, background color is black.)

The 240 days is as per the customers specifications. I agree that it is overkill, but it is what they want to be able to see, even though they will rarely go beyond the first forty or so. I know that this is not the source of my speed problem because I am currently working on a pared down version with only 50 columns.

So my problem is that I need to be able to set each cells color based on two criteria:
1. If the value in the cell is "Blackout", then the background color should be black.

2. Otherwise, the color needs to be based on the defined color for the plant. This color is stored as a numeric value in a field in the table.

So what you end up with is rows of different colors with blacked out cells scattered here and there based on days the plants not be producting, which will be different days for different plants.

I have been unable to get this to perform. I understand that rgb() is not as efficient as already having the number. By tweaking my code (which I know is far from perfect), I have created minimal improvements, but the performance is still very slow. If you know how I can make this improve any more efficiently, I would appreciate very much any suggestions.

Thanks,
Paul