test and fix a text string

[ghudson]

How can I check (and fix) if a user has keyed a name without typing a space after the comma? Don't blame me for I did not design this db but the users have to type the last name first, then a comma and a space and then the first name. The names are keyed into one text field (I can not change the design of the form or db) named txtName.

Example: Doe, John

I want to automatically fix the name if they incorrectly type the name like Doe,John (notice no space after the comma) so that the text string in the txtName field will be changed to Doe, John in the after update event of the text box.

Thanks in advance for your help!

 

[R. Hicks]

Go to Utter Access forums where I gave a solution to your question.

Link To Possible Solution

RDH