[AccessD] first caracter as Uppercase

Pedro Janssen pedro at plex.nl
Thu Apr 22 16:54:28 CDT 2004


Hello Drew,

how can i use this so that it sets all characters in all tables in a
database?

Pedro Janssen




----- Original Message -----
From: <DWUTKA at marlow.com>
To: <accessd at databaseadvisors.com>
Sent: Thursday, April 22, 2004 9:34 PM
Subject: RE: [AccessD] first caracter as Uppercase


> 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
> --
> _______________________________________________
> 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