I have entered default values on my form to save time. Is there an easy way to change the font color for values that were changed to something other than the default? This will signal the user that they have visited that record and that they may have changes 1 or 2 values in that record.
Here's a pretty easy approach off the top of my head:
Using the On_Current event of the form, rifle through the controls and change the color property of it's value matches the default.
A fast, efficient way to do it would be:
Dim ctl As Control
For Each ctl In Me.Controls
If Me.Tag = "CheckMe" Then
If ctl.Value = clt.DefaultValue Then ctl.ForeColor = 255 Else Me.ForeColor = 0 ' 255= Red, 0 = Black
For this to work, place the default value in each control's "DefaultValue" property and place "CheckMe" in each control's Tag property (don't use the quotes in the Tag property).
The down side of this is: in a continuous form, change the color of a text box and it changes the color of that text box in EVERY visible record.
There are more complicated methods of handling this in multi-forms, but for the sake of sanity, use a single form.