Need help

[Guest]

I have a form that has several text boxes whcih I use for inputting
measurements. They are labled box 1,2,3,4,5,6. There is also the same number
of field for the measurement I will be using for verification. There two two
other filelds that contain a +/- tolerence numbers. I would like the form to
determine if the measurement i have inputted to any given field could
indicate if
it was out of tolerance. I would like the box that indicated an out of
tolerance condition have the number in red. Is this possible, and could
someone help me with this?

 

[Todd Shillam]

Ron,

If your form displays a single record, that's pretty easy to do; provided you know a little VBA (Visual Basic for Applications). You can set form object's property settings via code using an event procedure, such as the 'After Update' procedure. For example, after entering the last required field, the 'After Update' event for the last required field would perform the subroutine.

For example:

Me![Text7].Background = red (something like this).

Basically, you would program an if-else statement.

If Me![Text1] > 0 Then
Me![Text7].Background = red 'Something like this--its been a while since I have done this.
Else
'DO NOTHING
End If


--
Best regards,

Todd Shillam
Information Technology Consultant
Shillam Technology
http://shillamtechnology.point2this.com


I have a form that has several text boxes whcih I use for inputting
measurements. They are labled box 1,2,3,4,5,6. There is also the same number
of field for the measurement I will be using for verification. There two two
other filelds that contain a +/- tolerence numbers. I would like the form to
determine if the measurement i have inputted to any given field could
indicate if
it was out of tolerance. I would like the box that indicated an out of
tolerance condition have the number in red. Is this possible, and could
someone help me with this?