Results 1 to 8 of 8
  1. #1
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Puzzling letter conversion (Acc '97 SR-2)

    I stumbled across a rather puzzling scenario yesterday. In the process of doing some string manipulation I created a simple table containing a record for each lower case letter a-z. When I opened the table in a query and calculated the Asc() value, the letter " i " appeared to be transformed to upper case according to the Ascii value. Interestingly when I click on that field, the display does indeed change to upper case. I found a workaround for the task I was attempting so this isn't a critical problem, I'm just very curious. <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29> Any idea what's happening here ?
    Attached Images Attached Images

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Puzzling letter conversion (Acc '97 SR-2)

    Happened to me too. Then I realized what happened. When you first typed your table and enterred "i", the Autocorrect feature changed it to "I" (that is, the capital letter). Annoying isn't it! I turn-off the autocorrect feature in my forms at the control level, only turning it on in certain situations. But in a table's datasheet view, I don't know how to turn if off.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Puzzling letter conversion (Acc '97 SR-2)

    You can only turn it off from the Tools menu. There isn't any other way to turn it off for a table.
    Charlotte

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Puzzling letter conversion (Acc '97 SR-2)

    >>You can only turn it off from the Tools menu. <<

    Where is the option to turnoff the autocorrect? If it is under Options, I can't see to find it.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Puzzling letter conversion (Acc '97 SR-2)

    No, it's the second item on the Tools menu itself and it's database-wide, if not Access-wide. That doesn't bother me because I always turn off the Replace Text as You Type option anyhow in Access.
    Charlotte

  6. #6
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Puzzling letter conversion (Acc '97 SR-2)

    Doesn't this change it Office-wide, not just for Access or a specificy database? I turn autocorrect on/off at control level anyway.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Puzzling letter conversion (Acc '97 SR-2)

    No, it just changes it for Access, not Office-wide. Unfortunately, there isn't any way I've ever found to turn it off at the table level, only at the Access level or for controls on forms.
    Charlotte

  8. #8
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Puzzling letter conversion (Acc '97 SR-2)

    Autocorrect <img src=/S/bingo.gif border=0 alt=bingo width=15 height=22> Obvious when you think about it.

Posting Permissions

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