continuous forms field values 2

[ocan]

I have a continuous form

The form setup is:

Test Name Test Result Lower Spec Upper Spec
Combo box [test result] [Text 118] [Text122]
values from query

I have to have the Test result a text box because some values are words and some are numbers. I am looking for some way to flag the user if a test result is "out of spec".(even if it is only the number values that would flag). What I have tried is setting another set of text boxes below it to a number field, 1 box=[Text 118]*1 and another box=[Text122]*1. Then if the value is a word it will read #Error. So I set another set of boxes =IIf([Text130]="#Error","",[Text130]) and =IIf([Text133]="#Error","",[Text133]). This doesn't work, if there's text in the box it always reads #Error. How do I get it to where if the field reads #Error, the text box be blank?

Thanks.

 

[Remou]

Have you looked at conditional formatting? It may suit. Also, you may find IsNumeric useful.

 

[PHV]

Have you tried to play with the IsNumeric function ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886