validation rule

[Guest]

I need to create a validation rule for a field that will hold either a five
digit number or the word "unknown". Is there a way to do this?

Thanks all

 

[Stefan Hoffmann]

hi John,

I need to create a validation rule for a field that will hold either a five
digit number or the word "unknown". Is there a way to do this?

Create a number field of type Long, allow Nulls. Add as validation rule
"[fieldName] BETWEEN 10000 AND 99999".

Use =Nz([fieldName], "unkown"] in any TextBox, where you like to display
the translation for Null.


mfG
--> stefan <--

 

[Guest]

I'm sorry I dont get it. Am I supposed to type this into the validation
field? and which of hte two statements goes there? Also it appears taht I'm
missing a close parentheses. I'm still quite a novice and sometimes need to
have it spelled our more clearly. Thanks and again, sorry.

hi John,

I need to create a validation rule for a field that will hold either a five
digit number or the word "unknown". Is there a way to do this?

Create a number field of type Long, allow Nulls. Add as validation rule
"[fieldName] BETWEEN 10000 AND 99999".

Use =Nz([fieldName], "unkown"] in any TextBox, where you like to display
the translation for Null.


mfG
--> stefan <--

 

[Stefan Hoffmann]

hi John,

I'm sorry I dont get it. Am I supposed to type this into the validation
field? and which of hte two statements goes there?

Your field:

Field Name: [yourNumber]
Data Type: Number

Set the following in the property editor for your number field:

Default Value: empty
Validation Rule: ([yourNumber] Between 10000 And 99999) Or ([yourNumber]
Is Null)
Validation Text: Enter number between 10000 and 99999.
Required: No



mfG
--> stefan <--

 

[Guest]

Thanks so much for your time and response. Best wishes to you. Today you
are my hero!

hi John,

I'm sorry I dont get it. Am I supposed to type this into the validation
field? and which of hte two statements goes there?

Your field:

Field Name: [yourNumber]
Data Type: Number

Set the following in the property editor for your number field:

Default Value: empty
Validation Rule: ([yourNumber] Between 10000 And 99999) Or ([yourNumber]
Is Null)
Validation Text: Enter number between 10000 and 99999.
Required: No



mfG
--> stefan <--