Validation Rule

[WayneSteenkamp]

I only want the user to be able to enter 9 numbers into the field including 0 in the beginning if needed.


I have this code in at the moment "Is Null OR Between 100000000 And 999999999", however if the number starts with a 0, it doesnt include it.
Any suggestions?

Else I'll just use an Input Mask

Wayne

[June7]

Number field will not save leading zeros. The field must be a text datatype then try InputMask property. Caution with number data in text fields: sort will be alpha not numeric. If values are not same length, results can be unsatisfactory.

[WayneSteenkamp]

I'm aware of that thanks

Just wanted to know if there was a way doing it as a Validation rule?

Thanks

[June7]

If they are allowed leading zero which means they are permitted 8 or 9 digits then that would be a range of 10000000 to 999999999?

What is this data for? Is this really a number or some sort of identifier like SSN or phone number or serial number?

[WayneSteenkamp]

its for a serial number. If i type a "0" first, it falls away once I leave the field. How do i keep it?

[June7]

Make field a text datatype and use input mask that requires character in every position.

[WayneSteenkamp]

Ok,No problem. Hopefully wont interfer too much with my relationships.

Thanks June7

[June7]

You have relationships based on this data? Will have to change field datatype on both sides. Also, if you already have 8-character values, will probably want to correct to 9 with leading zeros.