text box text color change (1 Viewer)

[dapfeifer]

Hey all,

I've got a form that monitors values as they vary between certain points of time, and I was wondering if someone could point me in the right direction for how to change the text color of the text box font if the value in that box goes negative. There are about 200 records the person can go through and I thought the afterupdate property would work, but that doesn't seem to be the case. If someone could give any suggestions I would appreciate it.

Thanks.

 

[Alansidman]

In your form in design view, right click on the control you wish to format, select conditional formatting. Put in your criteria and formattng desired and you should be good to go.

Alan

 

[tranchemontaigne]

you could also write code (OnCurrent event perhaps) to perform a test (to see if the value is greater than zero) and then dynamically set the forecolor property of the text box control using an if...endif or select case...end select statement
________
Alaska Medical Marijuana Dispensaries

 

[missinglinq]

Note that the method suggested in Post # 3 will only work if the form is in Single View. Conditional Formatting will have to be used for Continuous/Datasheet View forms.

 

[dapfeifer]

I appreciate the feedback. I had tried the OnCurrent event before posting the thread, but didn't get it to work. Conditional formatting seems to work perfect though, so I will go with that!

Thanks again for the help.

 

[missinglinq]

Glad you got it working!