[AccessD] Continuous form question

Thanks - I was about half way there - that's what I'm going to do.

Doug

On Thu, Feb 19, 2009 at 3:54 PM, Dan Waters <dwaters at usinternet.com> wrote:

> 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
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>