aziz rasul
Active member
- Local time
- Today, 00:03
- Joined
- Jun 26, 2000
- Messages
- 1,935
I have a field called Surname. I want to add validation in the table design so that if the name is typed in all lowercase, Access automatically makes Proper case e.g. smith becomes Smith. Is there a validation rule I can use that will do this.
In the Validation Rule property I tried [Surname] = StrConv([Surname], 3) it doesn't do anything.
I know I can use an update query to do this but just curious as to whether it is possible in table design.
In the Validation Rule property I tried [Surname] = StrConv([Surname], 3) it doesn't do anything.
I know I can use an update query to do this but just curious as to whether it is possible in table design.