Colouring edited field entries

[rollo]

I've looked on the various threads but cannot find any directly relevant info.
Is it possible to set up the fields on a form so that, when the data in the field has been edited/changed, either the font or background colour of that particular 'cell' automatically changes. I am using Access 97.
Any ideas would be greatly appreciated.

Many thanks, Rollo

 

[WayneRyan]

rollo,

Do you mean edited after initial creation, this month, or during this session?

Either way, you will need additional "flag" fields that will retain this info.
Code to set them when the data is actually changed. And more code to
alter the display format for the "current" record.

A bit of work, but definitely do-able in Access.

Wayne

 

[rollo]

Hi Wayne

Thanks for your help. Yes, I do mean changing the data after the initial input (eg a week or so later) - when some of the info will need amending.

Unfortunately, I am an absolute novice at coding. Would appreciate some guidance ...... bearing in mind that I'm pretty hopeless!

Thanks again
Rollo

 

[WayneRyan]

rollo,

Access is a database and is very adept at storing data.
It does not however store fonts, bolding, colors, etc.

Assume that you have a table with only the names of
100 people. If you want to track that their names
have changed, you will have to add a "flag" field to
show that.

Using a form's BeforeUpdate event, you can:

Me.TheirNameFlag = True

Now you know that the field has been changed.

When the form runs you can use the form's OnCurrent
event to:

If Me.NameFlag = True Then
   Me.TheirName.BackColor = SomeWeirdNumber
Else
   Me.TheirName.BackColor = TheRegularNumber
End If

As you can see, it's not trivial, but if you need to
do it, not really that hard. Of course, as the number
of fields that you want to track increases, so does
your level-of-effort.

Wayne

 

[rollo]

Wayne

Many, many thanks for your helpful explanation. Will have a go at your suggested codes.

Much appreciated.
Rollo

 

[Navyguy]

Wayne

How would you identify if data was changed a second or third or tenth time?

Say...total number of runs that a delivery driver would make to a specific location.

Is the colour change suggestion only good for one change, or could you say...have green for intial entry, yellow for first update, red for third update, etc?

 

[Rich]

Of course this won't work on continuous forms though