Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jun 2002
    Location
    Johannesburg, Gauteng, South Africa
    Posts
    59
    Thanks
    2
    Thanked 0 Times in 0 Posts

    User Input To Be Title Case (2000 SP3)

    Good morning (South African Time),

    I have a UserForm that has a TextBox called Section. The User inputs data into Section that is used for 2 purposes :
    Firstly, the data is inserted into the document ata abookmark and formatted to Uppercase.
    Secondly, the data is used as part of the FileName in the wdDialogFileSaveAs dialog box. This is where my problem comes in. The text entered by the user could be in any format (Upper Case, Lower Case, Mixed Case) but I want it to be in Title Case in thie dialog box. How do I ensure that this occurs?

    Thanks in anticipation.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: User Input To Be Title Case (2000 SP3)

    You can set the FileName to StrConv(Me.Section, vbProperCase)

  3. #3
    Star Lounger
    Join Date
    Jun 2002
    Location
    Johannesburg, Gauteng, South Africa
    Posts
    59
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: User Input To Be Title Case (2000 SP3)

    Hans, you are a star! Thanks very much.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •