Changing font color and style (1 Viewer)

Peter Paul

Registered User.
Local time
Today, 00:15
Joined
Jan 1, 2000
Messages
82
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
 

Travis

Registered User.
Local time
Yesterday, 16:15
Joined
Dec 17, 1999
Messages
1,332
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.
 

Users who are viewing this thread

Top Bottom