Version 1.4         Approx 0.9 MB (zipped)	First Published 29 Oct 2026

This article contains an example app demonstrating how reusable class module code can be used to highlight the current row and/or alternate rows in continuous forms.

The class module code was written by Access developer, Eric Blomquist, and is used here with the author's permission.

As with many class-based solutions, the underlying code is quite complex, but the main benefit is that it can be applied to any form with minimal code.
The following code is all that is required to make this work on any form:

Public owecRowHighlight As wecRowHighlight

Private Sub Form_Open(Cancel As Integer)
    Set owecRowHighlight = New wecRowHighlight
    Set owecRowHighlight.Form = Me
End Sub

The example app opens to a startup form with links to two working examples.


Each example form includes a highlight target combo box with 4 choices: None, Current Row, Alternate Rows, or Both with the default being alternate row colours.


Each form also includes two combo boxes allowing users to select the alternate row and current row background colours.
The alternate row colours are deliberately muted with the current row colours more pronounced.

The screenshot below shows pale yellow alternate row colours and the various colour choices available:


The next screenshot shows light red used for the current row colour and the various colour choices available:


All user choices update the form instantly without needing to reload the form.

Below are two screenshots of the other example form showing different combinations of both current row and alternate row colours:

Acknowledgements

All the class module code was written by Eric Blomquist and used by permission.
If you have any questions about the app, please contact Eric by email.



Download

Click to download:     EB_RowHighlighting v1.4      ACCDB - approx 0.8 MB (zipped)

As is the case for all files downloaded from the internet, first unblock the downloaded file, unzip then save to a trusted location.
For more details, see my article: Unblock downloaded files by removing the Mark of the Web



Feedback

Please use the Email button in the contact form below to let me know whether you found this article useful or if you have any questions.

Please also consider making a donation towards the costs of maintaining this website. Thank you

Colin Riddington	Mendip Data Systems	Last Updated 29 Oct 2026

Return to Example Databases Page

Return to Top