Validation Rule

Hello Katrina,

Thank you for your question regarding setting up validation rules in Access.

I came across this post today which does not appear to have been answered by anyone. Our sincere apologies for this oversight.

Here is what you need to type in as a validation rule for ensuring a user only enters 8 digits into a particular field.

Click in the validation rule properties and type:

Like "????????"

Enter the appropriate text message into the validation text section then save the changes and test.


I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Hello Katrina,

Thank you for your question regarding setting data validation rules in Access.

To force a user to enter a specific number of digits into a field do the following:

Enter the following into the Validation Rule:

Like "????????"

This rule forces the user to enter 8 digits only.

Then enter the Validation text and test to ensure it works.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer