Forms

[dr223]

Hi,

I have the code below which makes every initial of the surname_forename field start with a capital letter. Thats fine!!! So for example john, smith will be John, Smith

Me.surname_forename = StrConv(Me.surname_forename, vbProperCase)

However, this works ok if the user keeps a space after the comma. However, what I want to do is even if the user doesn't keep a space, it should be doing it automatically.

Also, the surname_forename is one field.

Any suggestions and help!!

Thank you

 

[Dennisk]

Search the forum for Proper this is function design to correctly case names.