capitalzie first letter each word

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i want to capitalize first letter of each word in my table. does this go in the input mask and how do i write it
 
Jenny,

If you mean the existing data, you need an Update query. In your query
design grid, in the Update To row of each of the fields that this
applies to, put...
StrConv([FieldName],3)

If you mean new data as it's entered (I notice your Shift key appears to
be broken... is this why you need this? :-), the best way is to put code
onthe AfterUpdate event of each applicable control on your data form(s),
like this...
Me.YourField = StrConv(Me.YourField, 3)
 
L<????????????? This worked for me. Right click on the
field while in form design go to properties and enter in
imput mask.
-----Original Message-----
i want to capitalize first letter of each word in my
Click to expand...
table. does this go in the input mask and how do i write
it
 
I think this method will work for the first letter of each entry in a
field, but not for each word.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Input mask help 4
How to type each letter of the alphabet automatically in a specific color in Word? 0
Title case using Input masks 3
Input mask for McC names 3
Excel Convert word into numbers and back 4
Format or Input Mask to allow specific letter case 2
Input Mask in Access 3
Upper Case 8

Back
Top