Validation rule to check for a space

[sra2786]

I need a validation rule that checks that the data is in the following format
[A-Z][A-Z][A-Z][A-Z]space[0-9][0-9][0-9][0-9][0-9]
I don't know how to include the space between the first four characters and the last five digits
Thanks.
Sandy

[June7]

Try:

LIKE "[A-Z][A-Z][A-Z][A-Z][ ][0-9][0-9][0-9][0-9][0-9]"

At least that works in my test in Immediate Window.

Perhaps InputMask would be better approach.

However, Access is not case-sensitive by default. If you want to enforce UPPER CASE will need VBA to convert alpha inputs to UPPER CASE regardless of approach to validate data.