Access Validation Rule - Leading Spaces

[LauraW]

Good Morning,

I have an access database that multiple users do data entry intro. I have both first and last name fields that are required. However, I am getting "blanks" in that fields because they are using the space bar and access considers that a character. Is there a validation rule that does not allow for leading spaces but will allow for spaces within the name such as De Rosa?

Thank you for your help.

Laura~

 

[Andrzejek]

This is an SQL Server forum, you should ask your question in one of the Access forums.

You can Trim your LastName / FirstName fields during Insert or Update, or at LostFocus event...?

Have fun.

---- Andy

There is a great need for a sarcasm font.

 

[LauraW]

Opps sorry.... wrong forum - lack of coffee this morning!. I will repost in the Access area!

Laura~

 

[SkipVought]

ALL your data entry ought to be via a Form that has all the validation necessary for each field.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]