Adding a Proper Case module

[ChrisHaynes]

Hi, I was looking at this archived thread: thread702-928808 about vbProperCase and creating my own proper case module. I have added the module to my database. Then I tried adding the code

Me.User = MyProperCase(Me.User, 0)

to the 'after update' section of my 'User' field text box.

However, when I type in a name in the text box, I get the following error:

Compile error: expected variable or procedure, not module

I think I am putting the code in the wrong place.

Can anyone help??

 

[Remou]

Have you called the Module the same name as the Procedure?

 

[ChrisHaynes]

Thanks Remou. That was the problem. I renamed the module and everything is fine now.

Thanks alot.