Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Tejpal, A.D.
  New Posts New Posts RSS Feed - HighLightDataSheetRows.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Please consider donating $1 per sample downloaded, (find out why here)


 Post Reply Post Reply
A.D. Tejpal View Drop Down
Microsoft MVP
Microsoft MVP

Joined: 30 Jun 2008
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote A.D. Tejpal Quote  Post ReplyReply Direct Link To This Post Topic: HighLightDataSheetRows.mdb
    Posted: 08 Jul 2008 at 10:46pm
This sample db demonstrates highlighting of datasheet rows in following styles
Current Row
Alternate Rows

Certain Special features
Anchor Row - In both alternatives (a) & (b) above, user can pinpoint any row as an
anchor row (if desired), by double clicking on it. The anchor row gets highlighted in
a special color and continues in this state, till some other row is pinpointed as the
new anchor row. If any existing Anchor row is to be put back to normal (without
pinpointing a new one), simply double click it again.

Over-riding conditional highlighting of individual cells (if desired) as per specified
criteria. In the sample db, Stock field gets special highlight if the value falls below
100. This special highlight holds good even when the row as a whole is highlighted
as current/alternate/anchor row.

In case of alternate row highlighting, the form, on opening, has color on odd rows.
For replacing it with color on even rows, simply double click on any even numbered
row. For reverting back to color on odd numbered rows, double click on any odd
numbered row.

Note - The technique used is completely non-obtrusive. It does not need any
special field (e.g. Yes/No or counter) to be added to the source table. No updating
or editing of source data is involved. No label or unbound text box is used. Only
requirement is that the source table should have a field holding unique values. In
this db, ID is such a field (autonumber type).

Download Access XP & 2K: uploads/37/


Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.