Format text

Guest · Feb 15, 2007

Hi,
I am just trying to set the format to capitalise the first letter.
I am using

L<???????????

But every time I change fields it changes to

<\L??????????

and I can't find why

Rodney

John Spencer · Feb 15, 2007

If you are doing this in a query, you can't do what you are attempting.
Your string looks like an input mask.

You can use a calculated field to display the data the way you desire

Field: UpFirst: UCase(Left([YourField],1)) & Mid([YourField],2)

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Format text

Guest

John Spencer