Changed to a Form Data are Bold on a Report

[johnb]

Hi All
I have a Access 2002 Form with 50+ textboxes & comboboxes. Where changes are
made to the data the After-Update events Bolds the data in that control. This
can happen many time on the same form. The problem I'm having is passing the
controls that have Bolded to a report. OldValue resets when the form looses
focus so I can't use that. Any suggestions??

TIA

johnb

 

[John Spencer]

There is no good way to do what you want beyond using a table to store the
fact that certain fields in a specific record have been changed. Perhaps you
can use something akin to Allen Browne's Audit Log idea. See:
http://allenbrowne.com/AppAudit.html

The information that a field has been changed (and when and by whom) is not
stored by Access.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

 

[johnb]

Cheers John S.

I'll come back when I've tried it out

johnb