Form does not allow me to save record based on "validation rule"

[skydivetom]

Experts:

This is a fundamental question, yet it appears that I'm stumbling on how to resolve it.

I have a numeric field with the following properties:
Field size = Double
Format = 0000000

Also, I added a validation rule/text such as:
- Validation rule: [Ra_BIN]<=7
- Validation text: You must enter a 7-digit BIN (incl. leading zeros)

Please see attached JPG for additional details.

Now, in the associated form, I am adding, e.g., a Ra_BIN = to "1234567" (for testing purposes only). This BIN is a valid number (i.e., it's less or equal to 7 characters); however, when trying to add other field data, the table's validation rule kicks in and prevents me from saving the record. Why is that? Again, the data input (as far as I'm concerned) does not violate the rule given its 7 characters. What am I missing?

Thank you,


EEH

[JoeM]

You aren't restricting the field length of 7 or less, you are restricting the field value to be 7 or less.
Try:

LEN([Ra_BIN])<=7

See here for more details: https://support.office.com/en-us/art...f-e3a0272e988d

[skydivetom]

JoeM:

In hindsight, your solution makes total sense. Tested it and it now works as intended. Thank you for your help!

EEH

[JoeM]

You are welcome!