Re: Help with capitalizing

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


"Bob Butler" <tiredofit@xxxxxxxxxxx> wrote in message
news:OPlYItH%23GHA.4472@xxxxxxxxxxxxxxxxxxxxxxx
"Ralph" <nt_consulting64@xxxxxxxxx> wrote in message
news:HvadneIjQ_b4SaLYnZ2dnUVZ_sCdnZ2d@xxxxxxxxxxxx
"J" <jk_50@xxxxxxxxxxx> wrote in message
news:OMf8ReH%23GHA.4712@xxxxxxxxxxxxxxxxxxxxxxx
Hi,
I have VB6 and SQL 2000. All our names are in capital letters.
Is there a syntax that will make the first letter in the fields
capital and the remaining lower case.

Thanks in advance.


The simple way

The simple way is
s=strconv(s,vbProperCase)


LOL

I had McDermott, MacDonald, D'Annunzio, L'Enclos, and O'Henry on my mind -
the first snippet I grabbed was for a textbox, and looked a bit silly so I
quickly chopped down the second version to do without the textbox or special
names - I didn't appreciate that by doing that I had merely recreated
strconv().

But I had fun.
<g>
-ralph






.

Relevant Pages

  • Re: Help with capitalizing
    ... e.g. Mary Smith-Jones or Jane Doe Smith (the dashes and spaces between ... All our names are in capital letters. ... Is there a syntax that will make the first letter in the fields ... the first snippet I grabbed was for a textbox, and looked a bit silly so I ...
    (microsoft.public.vb.database)
  • Re: Help with capitalizing
    ... I have VB6 and SQL 2000. ... All our names are in capital letters. ... Is there a syntax that will make the first letter in the fields ...
    (microsoft.public.vb.database)
  • Help with capitalizing
    ... I have VB6 and SQL 2000. ... All our names are in capital letters. ... a syntax that will make the first letter in the fields capital and the ...
    (microsoft.public.vb.database)
  • Re: Using a text box to enter in a password.
    ... I have created a login form for our users to enter their user ID and ... converted to lowercase and will read "Mypassword". ... users choose another password without any leading capital letters ... after the first letter, which is a workaround. ...
    (microsoft.public.access.formscoding)
  • Re: E-ZPass is Coming to the Illinois Tollway!
    ... > tollway website has nothing about ezpass or ipass working together. ... Do you know that you are supposed to capitalize the first letter of a ... "E-ZPass" has capital letters and a hyphen? ... here's a more direct link to the E-ZPass information you could ...
    (misc.transport.road)