Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2009

    Unanswered: Automatically change caps to smalls on user input?

    Hi. I've got a filter controlled by a combo box. THis has a list of addresses and when you type the address in the combo box is automatically brings up any that match.

    This works fine normally. However if the user has caps lock on, the first two letters work fine, but the third letter starts inserting the letters before the rest of the address (rather than replacing the letters as you type them), and thus ruining the filter.

    Is there a way to say "During update, make all characters small?"

  2. #2
    Join Date
    Jun 2009
    FOUND IT, changed allowautocorrect to Off in the combo's properties.

    But out of interest, what is autocorrect? it seems to ruin everything and i cnat see any time where it will be useful.

  3. #3
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    turn off autocorrect.. fine
    set a format mask
    and or put some code behind the forms on lost focus event or the before update event

    mycontrolnname.text = lcase(mycontrolnname.text)

    this uses the lcase function to return all lower case
    Ucase converts all characters to uppercase
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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