I'm in Access 2002.
How do I change the format from all caps to title case.I've tried an
update query but can't seem to get the proper syntax.
I've tried in the "update to" line in an update query, the following:

Format[placename]>L<??????????????

Placename is the name of the field.

Can someone please assist. Thanks for the help.

On Jan 9, 2:58=A0pm, jim.mclen... [at] servicecanada.gc.ca wrote:
> I'm in Access 2002.
> How do I change the format from all caps to title case.I've tried an
> update query but can't seem to get the proper syntax.
> I've tried in the "update to" line in an update query, the following:
>
> Format[placename]>L<??????????????
>
> Placename is the name of the field.
>
> Can someone please assist. Thanks for the help.

Google was my friend for you...
http://www.google.com/search?hl=3Den&q=3Dms+access+title+cas e

MyField=3DStrConv(MyField,vbProperCase)

Jon

On Wed, 9 Jan 2008 12:58:41 -0800 (PST),
jim.mclennan [at] servicecanada.gc.ca wrote:

> I'm in Access 2002.
> How do I change the format from all caps to title case.I've tried an
> update query but can't seem to get the proper syntax.
> I've tried in the "update to" line in an update query, the following:
>
> Format[placename]>L<??????????????
>
> Placename is the name of the field.
>
> Can someone please assist. Thanks for the help.

In a query?
NewColumn:StrConv([FieldName],3)

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail