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 - Form_HighLightUpdatedFields.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

>
Want a good read? Try The Summer of His Life (available on Amazon!)

Form_HighLightUpdatedFields.mdb

 Post Reply Post Reply
Author
Message
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: Form_HighLightUpdatedFields.mdb
    Posted: 09 Jul 2008 at 10:25pm
This sample db enables the user to identify at a glance as to which fields in which 
records have been updated in the current data entry session. The most demanding 
scenario is that of a datasheet form. The objective is achieved through run time 
manipulation of format conditions. 
 
The db incorporates following features:
    (a) On opening the form, all display is normal - no highlights yet.
    (b) Fresh records added in current session get highlighted in light blue back 
         color, with bold font in black forecolor.
    (c) Any cell (i.e. given field on given record) updated for the first time in current 
         session, gets highlighted in light orange back color, with bold font in dark red 
         forecolor.
    (d) Any cell (i.e. given field on given record) updated more than once in current 
         session, gets highlighted in light pink back color, with bold font in dark red 
         forecolor.
    (e) At any stage, if so desired, all highlights can be removed (signifying the start 
         of next session), by clicking the command button captioned "Remove 
         Highlights"
    (f) On closing the form, it starts with a clean slate (i.e. no highlights), when 
        opened next time. Fresh highlights take effect progressively, as and when 
        fields are updated in the new session.

Download Access 2K/XP/2K3: uploads/37/Form_HighLightUpdatedFields.zip

--

Email: adtejpal@gmail.com
Back to Top
Sponsored Links
>
Want a good read? Try The Summer of His Life (available on Amazon!)

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.