Forecolor property in expression

JakeN

Registered User.
Local time
Today, 03:41
Joined
Sep 1, 2000
Messages
13
how can you set the foreground color property thru just an expression? I'm trying to set the color of a control in a form. I can do it through a macro but for some reason I can't thru the control's events or data source.
Thanks
 
Lots of possibilites here... I do not know what you are trying to do but you can put an [Event Procedure] in the After Update, On Enter, On Exit, etc. of the control that will change the controls forecolor. Code like Me![ControlName].ForeColor = 255 will change the forecolor to red depending on which Event you select for your code. A bit more information on what you want to do will help us to be more specific with an answer.
 
Well I had an idea...but it didn't work. I'm trying to hightlight only certain records in a continuous form. I've been looking online and evidently its a pretty hard thing to do.
 
It sounds like you're trying to get conditional formatting, this is a built-in feature in access 2000, but in access 97, it can be done with a bit of fiddling; I have a demo database which you might find useful.

If you would like a copy of the demo, email me and I will send it by reply (make sure you mention conditional formatting in the email subject, as I get a lot of different requests)

HTH

Mike
 
Dude! Conditional formatting is the magic word. I know how to do what I want now. Thanks mike
 

Users who are viewing this thread

Back
Top Bottom