capitalzie first letter each word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jenny - 29 Jan 2004 22:36 GMT

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

Reply to this Message

Steve Schapel - 30 Jan 2004 03:43 GMT

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)

Signature

Steve Schapel, Microsoft Access MVP

> 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

Reply to this Message

- 30 Jan 2004 17:41 GMT

>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 table. does this go in the input mask and how do i write

Reply to this Message

Steve Schapel - 30 Jan 2004 18:07 GMT

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

Signature

Steve Schapel, Microsoft Access MVP

> >L<????????????? This worked for me. Right click on the
>
> field while in form design go to properties and enter in
> imput mask.

Reply to this Message