Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002
    Posts
    59

    Unanswered: Access 97 and Propercase Conversion

    Hi,

    This will work in a query and convert Field2 to Propercase as Field1
    Field1trConv([Field2],3)

    Any suggestions to deal with O'DONOVAN to O'Donovan, o'mahony to O'Mahony or MCCARTHY to McCarthy?

    Thanks

    Frank

  2. #2
    Join Date
    Nov 2001
    Posts
    336
    Hi,

    You can take function posted here: http://dbforums.com/showthread.php?s=&threadid=377609 and modify it to handle O'Henry and McCarthy.

    Igor

Posting Permissions

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