Text formatting

  • Thread starter Thread starter Rob
  • Start date Start date
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.
 
Try looking at Microsoft Knowledge Base Article - 815282
(Convert a Text Data Type to Proper Case Format (Title
Case Format)) as a starter.

Alastair
 
Back
Top