Access table (1 Viewer)

[sree]

how do I validate table field to check no of digits to enter
example:
I would like to enter only 7 digits in a field, it should not accept lesser than 7 digits or more than 7 digits

Thanks

 

[DanWall]

set the validation rule on the table field to:

Like "???????"

 

[sree]

set the validation rule on the table field to:

Like "???????"

Thank you very much it is working perfect