[AccessD] Continuous form question

Here's an easy to code solution:

1) For each editable field in the table, create a duplicate field with a
slightly different name.

2) In the form, add a non-visible control which is bound to the duplicate
field.

3) When a field is changed, in the afterupdate event, write the original
value of the visible control to the invisible control.  If someone rewrites
the original value into the visible control, then clear the invisible
control.

4) For each visible control, add a conditional format which changes the
background color of the visible control if there is a value in the
corresponding non-visible control.  

5) When you finally save your changes, be sure to clear all the duplicate
fields.

Good Luck!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
Sent: Thursday, February 19, 2009 3:35 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Continuous form question

Hello:

I have a large continuous form which will normally be showing about 600 rows
of around 20 columns.  After editing it, my client would like some kind of
visual clue as to which individual cells in the form have been updated, so
that someone else can quickly look it over and see where changes have been
made. Does anyone have a good way of doing this?  So far, any way I've
thought about has been really ugly to implement.

Thanks,

Doug Steele
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com