Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Nov 2001
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Character Converstion (2000)

    I am importing a database that is IN ALL CAPS and I want it to be Case Proper. How would I convert the data, not just a mask but actually convert it so when I export it it will be correct.

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

    Re: Character Converstion (2000)

    Use an update query.
    In the Update to line use StrConv([YourField],vbPropercase)
    Francois

  3. #3
    New Lounger
    Join Date
    Nov 2001
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Character Converstion (2000)

    I get a type conversion failure when running this expression

  4. #4
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Character Converstion (2000)

    If using StrConv function in a query expression, use the vbProperCase constant's numerical value rather than named constant, e.g.: <pre>StrConv([FLD_NAME],3) </pre>

    The Object Browser will provide the numerical equivalent for named constants, e.g. Const vbProperCase = 3.
    HTH

Posting Permissions

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