Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Validation rule on NZ field

Status
Not open for further replies.

Zed5010

IS-IT--Management
Oct 9, 2005
42
CA
I have a form and need to validate a field that is NZ.

ex. [field1]=10 [field2]=blank

[field2]
validation rule required: <=[field1]

Does not work since field2 is blank, only if I enter "0".

error msg:
" Object doesn't contain the automation object 'field1' "

Any help will be much appreciated.

Zed
 
How are ya Zed5010 . . .

Your post origination is extremely vague! . . . but if I try to follow it:
Code:
[blue][field1] = 10 [field2]
    shuold be:
   [field1] = 10 * Nz([field2])[/blue]
Any Closer?

Calvin.gif
See Ya! . . . . . .
 
Hi TheAceMan1:

Sorry about the vagueness...

figured it out :

<=[field1] or is null

Thanks for the response.

Cheers!


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top