To change the color of the text of any field you need to use this code:
Me.FieldToChange.ForeColor = 11223322 'The New color.
Place this on the AfterUpdate event of the field that Effects the color change.
Note: If you are using a continuous form and not using Access 2000 the color will change in all records until it is reset. This supposibly has change in Access 2000 (New feature that I had been praying for since 2.0). Otherwise if you are using a single form view you will have no problems.