Convert Access table of names

[Guest]

I want to merge a table of names/address with Wble ORD documents. However,
the table has name field in all capital letters; I want it converted to
lowercase letters. What do I do?

 

[Allen Browne]

Export a query instead of the table.

In the query, you can type something like this into the Field row:
LCase([NameField])

Or if you want the first letter to remain upper case:
StrConv([NameField], 3)

 

[Guest]

THANK YOU!

Export a query instead of the table.

In the query, you can type something like this into the Field row:
LCase([NameField])

Or if you want the first letter to remain upper case:
StrConv([NameField], 3)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I want to merge a table of names/address with Wble ORD documents. However,
the table has name field in all capital letters; I want it converted to
lowercase letters. What do I do?