Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jul 2002
    Location
    Manchester, UK
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Text Formatting (Access 2000)

    Is there a way of easily converting an entire table of data from Uppercase to Title Case format ? Any help would be appreciated, thanks.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Text Formatting (Access 2000)

    If you mean with Title Case format, the first letter of each word in upper case and the rest in lower case use an update query.
    In each text field on the line Update to use:
    StrConv([YourField],3)
    Francois

  3. #3
    New Lounger
    Join Date
    Jul 2002
    Location
    Manchester, UK
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Text Formatting (Access 2000)

    <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23> Thank you very much for your help. You have saved me a great deal of work

Posting Permissions

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