Create Subforms with Alternate Row Colors (1 Viewer)

[mresann]

When you create an Access Report with a subreport control, you can use VBA to format the Detail section to create alternating colored rows. Unfortunately, subforms do not share the same versatility as subreports. However, you can create rows of alternating colors by adding a field to the query providing for the underlying source object for the subform, and using this field to create an expression to provide the Conditional Formatting function for subform controls. Added bonus: No VBA is necessary! All formatting calculations are provided at design time.

The zip file included is the same one I used to submit to Planet Source Code, and was similar to the one posted on this site previous to the malicious purge.

This tutorial includes a complete instruction htm file to assist you in the step-by-step process, in addition to a fully functioning database with examples.

 

[Keith Nichols]

[QUOTE
This tutorial includes a complete instruction htm file to assist you in the step-by-step process, in addition to a fully functioning database with examples.[/QUOTE]


Hi mresann

Thanks for the turorials - as a complete beginner, this sort of thing is very helpful in my learning process.

Regards,

Keith.