Capitalization

[Leesha]

Hi,

I have a query that is returning results based on the way they were entered into the database. In some cases thery were entered in all caps, and in other cases they were entered with the first letter as a capitol and the remained lower case. This is the way I want them. Is there a way to format [city] so that it is uppercase for the first letter and lower case for the remainder?

Thanks,
Leesha

[Wendell]

Check out the StrConv function - it will do the trick for you. See StrConv Function - the choice you want for the second parameter is 3 or vbProperCase.

[Leesha]

Thanks!!!