>--snip--
>>I believe this is the example in the help
>>Arnon
>
>-- reply --
>Not quite. The example in help is base on the record number linked to the row. This only results in alternating white/green bars if the records are in odd/even order. But assume my record source has the following record number links
>
>Row1 -> record 4
>Row2 -> record 6
>Row3 -> record 12
>
>such as would happen with one to many links. All of the records would be displayed in white (or green). There would be no alternating colors since all of the records are even.
>
>My question is how to use dynamicbackcolor to display alternating green and white rows irrespective of record number.
>
>I don't think it can be done using dynamicbackcolor.
>
>regards,
>
>JME
This maybe an indirect argument for using views thruout an app (I'm a CB buff). In the cursors the recno's are always 1 to n regardless of the complexity of the SQL the created them even if many joins, fors, wheres. This allows a basic custom grid to be built using the AfterRowColumn change for recno setting and DynamicBackcolor in the controls. The grid can build itself basic on the data types of the control sources and us a backcolor aware textbox,edit,check, etc.
FWIW