capitalzie first letter each word

J

Jenny

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
 
S

Steve Schapel

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)
 
G

Guest

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
 
S

Steve Schapel

I think this method will work for the first letter of each entry in a
field, but not for each word.
 
Top