Help with continuous forms 4

[RickBerem]

Hi,
I have a form where a lab operator inserts the results of some tests on the products. I also have a min and max for each result that the operator writes in.
When the result isn't between the min and max the backcolor of the textbox turns red. It's ok for that... my problem is when the textbox (txtAcid) turns red, all other txtAcid in the continuous forms turns red too?

what I'd like is that only this txtAcid turns red and if the next isn't between the min and max well then It gets red.

Any help or ideas?

thanks

RickBerem

 

[petermeachem]

You could do this.

Put a text box that stretches right across the form in the detail bit, and make sure it is behind the other controls.

Set the control source to
=IIf(Not [Confirmed],"ÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛ
ÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛ
ÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛÛ",Null)

The font must be terminal, and the Û is a block. If this post makes no sense, I'll mail you a form with it in.

PS In your case Confirmed would be txtAcid < 10 or whatever.

 

[RickBerem]

Thanks Peter,

but I'd really like to see the exemple.

please e-mail it to RickBerem@hotmail.com

thanks

RickBerem

 

[RickBerem]

Hi,
I really need the backcolor to change!!! is it possible?

thanks for your help

RickBerem

 

[petermeachem]

Can't think of a way of doing that with Access. The supplied code will light up whichever part of the detail line you put it behind. You might have to use VB, or at least a grid ocx. You might try the Janus one, I'm not sure if it can light a cell dependent on value or not.

 

[ghubbell]

Hi Rick, You're using Access 97 and a continuous form? No can do without third party intervention. Cheaper fix: Change your form to single form view or upgrade to Access 2000. If you are using 2000 already then check out &quot;conditional formatting&quot;. It's exactly what you want and can handle this situation in continuous forms, and anywhere else! Gord
ghubbell@total.net

 

[RickBerem]

Hi,
Ok then thanks Gord.

Peter I used your idea and I managed to make it do what I want. Thanks!

RickBerem