Form_HighLightUpdatedFields.mdb |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
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.
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |