Loading ...
Sorry, an error occurred while loading the content.

Re: Proper Name

Expand Messages
  • Chad Gould
    ... Er, because there is. See the StrConv function and use vbProperCase as the flag.
    Message 1 of 5 , Aug 1, 1999
    View Source
    • 0 Attachment
      > There is _no_ ProperName function in Access97. If there were, I
      > imagine it'd take a String and return a String. What made you
      > think there _is_ such a function in Access?

      Er, because there is. See the StrConv function and use vbProperCase as the
      flag.
    • Chris Kelly
      I guess I ve never had much use for it :) Mea culpa. ... +-------------------------------+-----------------------------------------+ ...
      Message 2 of 5 , Aug 1, 1999
      View Source
      • 0 Attachment
        I guess I've never had much use for it :) Mea culpa.

        > From: "Chad Gould" <Chad_Gould@...>
        >
        > > There is _no_ ProperName function in Access97. If there were, I
        > > imagine it'd take a String and return a String. What made you
        > > think there _is_ such a function in Access?
        >
        > Er, because there is. See the StrConv function and use vbProperCase as the
        > flag.

        +-------------------------------+-----------------------------------------+
        | Chris Kelly | ,-_|\ This here's the wattle |
        | Chris Kelly Computer Services | / \ the emblem of our land |
        | chris@... | \_,-._/ You can stick it in a bottle |
        | ICQ 9757294 | v or you can hold it in yer hand |
        +-------------------------------+-----------------------------------------+
      • TOM CURRIER
        Here Goes: Public Function Proper(strToChange As String) As String Converts string to Proper case On Error Resume Next Proper = StrConv(strToChange,
        Message 3 of 5 , Aug 2, 1999
        View Source
        • 0 Attachment
          Here Goes:

          Public Function Proper(strToChange As String) As String
          ' Converts string to Proper case
          On Error Resume Next
          Proper = StrConv(strToChange, vbProperCase)
          End Function

          Tom Currier
          Database Specialist
          Landels Ripley & Diamond, LLP
          Phone: (415) 512-8700
          Fax: (415) 512-8750
          e-mail: thc@...
          http://www.landels.com

          The information contained in this e-mail message may be privileged,
          confidential and protected from disclosure. If you are not the intended
          recipient, any further disclosure or use, dissemination, distribution or
          copying of this message or any attachment is strictly prohibited. If you
          think that you have received this e-mail message in error, please e-mail
          the sender at the above address, and delete the e-mail. Thank you very
          much.



          -----Original Message-----
          From: Chris Kelly [mailto:chris@...]
          Sent: Saturday, July 31, 1999 7:41 AM
          To: accessaskme@onelist.com
          Subject: Re: [accessaskme] Proper Name


          From: "Chris Kelly" <chris@...>

          There is _no_ ProperName function in Access97. If there were, I
          imagine it'd take a String and return a String. What made you
          think there _is_ such a function in Access?

          There _is_ a Proper() function in Visual Basic, but Access Basic
          (VBA) is _not_ Visual Basic.

          > Does anyone know how I can use the "ProperName" function in Access97? I
          > can't find anything about it in any books or the M/Soft web site. Thanks
          > Sue
          >
          > --------------------------- ONElist Sponsor ----------------------------
          >
          > Create a list for FRIENDS & FAMILY...
          > ...and YOU can WIN $100 to Amazon.com. For details, go to
          > http://www.onelist.com/info/onereachsplash3.html
          >
          > ------------------------------------------------------------------------
          > Tell yout friends to subscribe too :)
          >


          +-------------------------------+-----------------------------------------+
          | Chris Kelly | ,-_|\ This here's the wattle |
          | Chris Kelly Computer Services | / \ the emblem of our land |
          | chris@... | \_,-._/ You can stick it in a bottle |
          | ICQ 9757294 | v or you can hold it in yer hand |
          +-------------------------------+-----------------------------------------+

          --------------------------- ONElist Sponsor ----------------------------

          GET WHAT YOU DESERVE! A NextCard Platinum VISA: DOUBLE Rewards points,
          NO annual fee & rates as low as 9.9 percent FIXED APR.
          Apply online today! http://www.onelist.com/ad/nextcard1

          ------------------------------------------------------------------------
          Tell yout friends to subscribe too :)
        Your message has been successfully submitted and would be delivered to recipients shortly.