Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jan 2008
    Location
    Wheaton, Illinois, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I can format a field as uppercase. Can I format a field for Title Case, so that if I enter in lower case, one word or multiple word cities will capitalized correctly? (With my State field, capitalization shows when I proceed to the next field.) BTW, I prefer to enter data right from the table.

    I'm not initially asking about macros...just as-I-go formatting.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    The bottom line answer is no - you cannot set a field to be formatted Title Case in a table property. However with the Format function, you can do it on a form or in a query.
    Wendell

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Quote Originally Posted by halfmybrain View Post
    BTW, I prefer to enter data right from the table.

    I'm not initially asking about macros...just as-I-go formatting.
    In case you change your mind about both of these things, you can use the after update event of a control on a form to convert the text entered into title case.

    For example:

    Code:
    me.StreetAddress = StrConv(me.StreetAddress, vbProperCase)
    Regards
    John



  4. #4
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post
    It is good practice to keep users from direct access to tables. For reasons like this one - ie lack of events to control the user's input.

    However in Access 2010 you will be able to use events in tables to run macros. There is an AfterUpdate which will run when a change is made to a field and a BeforeChange which runs when the user moves to a different record.

Posting Permissions

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