[AccessD] first caracter as Uppercase

DWUTKA at marlow.com DWUTKA at marlow.com
Thu Apr 22 14:34:17 CDT 2004


StrConv("this is a test",vbProperCase)


results in:


This Is A Test

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Pedro Janssen
Sent: Thursday, April 22, 2004 2:09 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] first caracter as Uppercase


Hello Group,

i have a code (thanks to Brett Barabash and Mark A Matte) that sets all
characters in all tables to Lowercase.

What i also would like to see is each character at the beginning of a word
(each word that is separated by a space) is set to Uppercase in all Tables
by just one code.
Is this possible. Who can help me with this?

TIA

Pedro Janssen
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list