[AccessD] Converting case

I rarely do this but I decided to look up what MSFT had to say about
StrConv function.

I was surprised to see in this post, a second argument in an assignment
statement (i.e., equal sign expression). Is that valid?
http://office.microsoft.com/en-us/access-help/strconv-function-HA001228915.aspx
 Furthermore, using () in a byte declaration? I thought that was for
variants?

I feel like such a know-nothing!

Dim i As Long

Dim x() As Byte
x = "ABCDEFG", vbFromUnicode ' Convert string.
For i = 0 To UBound(x)
    Debug.Print x(i)
Next



On Wed, Feb 26, 2014 at 1:26 AM, Bob Gajewski <rbgajewski at roadrunner.com>wrote:

> Temp = StrConv(Temp, vbProperCase)
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stephen Bond
> Sent: Wednesday, February 26, 2014 00:59 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Converting case
>
> http://support.microsoft.com/kb/815282
>
> Method 1 looks promising
>
>
> Stephen
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kathryn Bassett
> Sent: Wednesday, 26 February 2014 6:00 p.m.
> To: Stephen
> Subject: [AccessD] Converting case
>
> On to another. Googling gets me some answers for Excel, but not Access.
>
> https://www.dropbox.com/s/c5cg7uji1kkhr0i/ConnerBishopHistoriesPlay.accdb
>
> In the Histories table, I converted the Country field using Find/Replace.
> But I don't relish the time required to do that with StateProvince, County,
> and Town. Is there a quick way to change those to first letter upper case,
> rest lower case?
>
> For instance NOVA SCOTIA to Nova Scotia, SAINT JEAN to Saint Jean, CLARKE
> COUNTY to Clarke County?
>
> --
> Kathryn Rhinehart Bassett (Pasadena CA)
> "Genealogy is my bag" "GH is my soap"
> kathryn at bassett.net
> http://bassett.net
>
>
>
>
> --
> 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
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
*Regards,*


*Bill Benson*
*VBACreations*

PS:  You've gotten this e-mail *because you matter to me!*