> I'm writing an app that is basically a flow model where the data on a
> table
> (that can vary in column count depending on the model picked up by
> the
> grid) has properties that simulate the behaviour of a pile of coal.
> There
> are only 8 lines(records) used on the table at all times.
> Now, the different colors represent different types of coal (chemical
> composition, etc.) and each box in the grid represents 200 tons of
> coal.
Yes, it can be done, but you may find it a pain.
Set up a cursor with x fields across and y rows, where x is the number
of columns that you want to display and y is the number of rows. (I'm
assuming that you want the scroll bars, so the count of columns can't be
accurately determined, and you may want more than 8 rows). Each of the
fields across is a single digit numeric value, and this value
corresponds to the table of colurs (assuming something like 1=light,
2=darker, 3=darker, 4=darker, etc.).
Set up the Grid control with the number of columns matching the number
of columns in the table. If the number of column in the table changes,
then you will have to set this Grid up programmatically.
Have a Shape as the single object in the Grid. Have the colour of the
shape be based on the table of colours, and the colour be based on the
value in the cursor. Or, to make things easier, have the same type of
code that was presented a few days ago with nested IIF()s in the
DynamicBackColor.
And it should work.
/Paul