469,645 Members | 1,360 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,645 developers. It's quick & easy.

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

72
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.
May 31 '07 #1
5 20696
post removed by user, edit to follow... sorry for the delay.
May 31 '07 #2
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
May 31 '07 #3
Rotor
72
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.
May 31 '07 #4
missinglinq
3,532 Expert 2GB
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."
May 31 '07 #5
MMcCarthy
14,534 Expert Mod 8TB
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), ....
Jun 1 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by dude | last post: by
9 posts views Thread by Andy Chalkley | last post: by
2 posts views Thread by Bob | last post: by
1 post views Thread by John | last post: by
ADezii
1 post views Thread by ADezii | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.