[AccessD] Converting case

William Benson vbacreations at gmail.com
Wed Feb 26 16:40:38 CST 2014


Answered my own question in part, that it is declaring an array of type
byte... But the parameter after the equal sign.


On Wed, Feb 26, 2014 at 5:38 PM, William Benson <vbacreations at gmail.com>wrote:

> 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!*
>



-- 
*Regards,*


*Bill Benson*
*VBACreations*

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


More information about the AccessD mailing list