Text formatting

R

Rob

Hello

I have a form with separate text boxes for clients' first
and last names. The problem is the form's source is a
table that already had pre-existing data in it. The
client's first and last names are enter sometimes as upper
case or lower case or anything between.

But all I want is for the first letter in the last and
first name to display as being upper case. Then the rest
of name be lower case.

I know can use > or < to make text be upper or lower caps
but how do you do it for just the first letter? Thanks.
 
A

Alastair MacFralane

Try looking at Microsoft Knowledge Base Article - 815282
(Convert a Text Data Type to Proper Case Format (Title
Case Format)) as a starter.

Alastair
 

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

Top