Results 1 to 3 of 3

Thread: Make Caps Query

  1. #1
    Join Date
    Jan 2002
    Location
    Nottingham - UK
    Posts
    113

    Unanswered: Make Caps Query

    Hello -

    I need a turn a field of all lower case text into First Letter Capitlisation - can anyone help with this please ?

    Best Regards

    Donald

  2. #2
    Join Date
    Nov 2001
    Posts
    336
    See Apel's function in thread:

    http://dbforums.com/showthread.php?s=&threadid=377609

    Igor

  3. #3
    Join Date
    Feb 2002
    Posts
    108

    This may be easier....

    Use "StrConv"
    The following example changes to first letter capitalization, although you will still see the problem as described in the above link, with abbreviations. But see what you think.


    Me![Description] = StrConv(Me![Description], vbProperCase)

Posting Permissions

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