Input mask upper case first letter of each word in field.

[Rotor]

Okay I know how to upper case the first word. However, how do I make it so first letter of each word in the same field is capitalized?

Thxs.

[theaybaras]

post removed by user, edit to follow... sorry for the delay.

[theaybaras]

Sorry for the closed relply a few minutes ago, posted a comment to the wrong thread! Now that I'm paying attention, here's the reply I meant to give you!
--------------------
Hi there,

Lots of info available on this in this forum, the MS Access help file and elsewhere online. See if these help:

informative thread in thescripts142

using an update query to do this (thescripts142)

Using VB code to accomlish the task

Another resource for mixed cases

Hope this helps! If not, what are you currently using to change the first letter of the first word to uppercase?
something like
>?<???? or something different?

theAybaras

[Rotor]

Seems more trouble than is worth. Plus it doesnt affect my functionality, was just trying to make it look purdy.

I was using >L<??????????????

Edit: Thank you for your time looking up those links.

[missinglinq]

You need to clarify exactly what it is you're trying to do!

First you say "Okay I know how to upper case the first word. However, how do I make it so first letter of each word in the same field is capitalized?"

Then you say "Change the first letter of the first word to uppercase?"

Which is it you're trying to do?

If it's the former , then following DFS's advice in the first link you site

You might do better my putting some code to change the capitalization in the Exit or AfterUpdate event:

me.txtField = strconv(Me.txtField,vbpropercase)

will do! If it's the latter you already know how to do that !

"Okay I know how to upper case the first word."

[MMcCarthy]

Okay I know how to upper case the first word. However, how do I make it so first letter of each word in the same field is capitalized?

Thxs.

If you are talking about doing this in a query then

SELECT StrConv([Field],3), ....