By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,313 Members | 2,725 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,313 IT Pros & Developers. It's quick & easy.

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

P: 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
Share this Question
Share on Google+
5 Replies


theaybaras
P: 52
post removed by user, edit to follow... sorry for the delay.
May 31 '07 #2

theaybaras
P: 52
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

P: 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
Expert 2.5K+
P: 3,532
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
Expert Mod 10K+
P: 14,534
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.