How is it possible to change the text color in a drop-down field depending on the selection? I would like to designate different colors for different events on a log. Thanks for any help.

Peter Paul

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.