conditional formatting if changed today

[kbrooks]

On a form that collects physician information, there is a button the user can click that will send a report of everything the form contains to me through email, in a Word document. (We are currently moving from one system to another so we have to enter the same changes in 2 systems until go live)

The problem is,there's no way to tell at a glance whether a particular field was changed, so I have to compare every field with what I have in the system. It works, but there's about 40 fields, and I get many many reports during the day, so it's become quite time consuming.

I've been looking into conditional formatting, but I'm kind of unsure what field I should base the condition on. Do I need to have a date field for each field, that updates with the current date? And then have my condition look at that date field? I'm not quite sure how that would work...

I just need some way of indicating what fields the user has changed during that session.

Thanks for any advice!

 

[kbrooks]

I'm going to bump this one time. Anyone have any advice?

 

[Galaxiom]

Yes you are on the right track.
You would need to store another field in the table for each field with a date stamp for the change.
The condition for changed today would be:

Expression Is| [datestamp]=Date()

However I would be importing the supplied data and letting Access do the work.