Re: Help with capitalizing

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

Thanks for all the input. It worked. Now suppose I have a two word name
e.g. Mary Smith-Jones or Jane Doe Smith (the dashes and spaces between
names?


"Ralph" <nt_consulting64@xxxxxxxxx> wrote in message
news:0LudnY-3vOU6YKLYnZ2dnUVZ_vGdnZ2d@xxxxxxxxxxxxxxx

"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
    ... 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: 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)
  • Re: Hypothesis Sought...
    ... initial capital letters are used only in the first ... letter of a sentence and the first letter of a proper noun. ... Support the troops: Bring them home ASAP. ...
    (comp.sys.mac.system)
  • Re: Auto Complete
    ... I input the first letter "A" in the textbox, ... got the similar coding for a VBA one but it cannot apply to VB6 because ... those contains specific programme objects in it. ...
    (microsoft.public.vb.database)