[AccessD] UPPER-CASE to Upper-Lower-Case

Try this:

Dim strString As String

strString = "THIS IS BIG"

strString = StrConv(strString, vbProperCase)

Msgbox strString

(Should now be This Is Big)



 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Garraway, Alun
Sent: 21 April 2005 08:59
To: Access Developers discussion and problem solving
Subject: [AccessD] UPPER-CASE to Upper-Lower-Case

hello,

is it possible to turn a string in upper-case to upper-lower-case?

for example

"THIS IS BIG" to "This Is Big"

TIA :-)

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