Results 1 to 7 of 7
  1. #1
    kdbailey is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Aug 2012
    Posts
    228

    Textbox OnChange Event Delayed Until Done Typing

    Is there a way for the OnChange event to wait until you're done typing (maybe a one second delay)?



    I want my textbox to filter another listbox and don't want it filtering every single keystroke. I'd like it to filter once you're done typing for roughly a second.

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,540
    don't want it filtering every single keystroke
    Why not just use a different event. Maybe After Update ?
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,722
    I agree with Bob, use a different event. If you want of validate/verify a value after it has been entered completely, then AfterUpdate of the control seems appropriate.
    Perhaps you could tell us more about the requirement.

  4. #4
    kdbailey is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Aug 2012
    Posts
    228
    After update would require exiting the textbox in some fashion, correct? I'd prefer not to do that as well.

    If this is not possible without going into lengthy Form Timers then I'll just live with the current filtering per keystroke.

  5. #5
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,722
    Perhaps you could tell us more about the requirement in simple, plain English - just as you would tell an 8yr old.
    What exactly are you trying to accomplish? Once readers understand WHAT, there may be options for How to do it in Access.

  6. #6
    kdbailey is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Aug 2012
    Posts
    228
    I'll put aside that disrespectful comment and lay it out in plain english, as my opening post stated pretty clearly itself.

    Step 1) Type into textbox
    Step 2) Listbox RowSource is filtered based on what you typed in step 1

  7. #7
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,722
    No disrespect intended.

    It was your quasi -description/questions/acceptance - that prompted me to ask for clarity/details/example.

    After update would require exiting the textbox in some fashion, correct? I'd prefer not to do that as well.
    If this is not possible without going into lengthy Form Timers then I'll just live with the current filtering per keystroke.

    Good luck with your project.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 05-04-2017, 07:23 AM
  2. Replies: 4
    Last Post: 04-23-2016, 02:14 AM
  3. Undo Typing in Unbound Textbox
    By June7 in forum Programming
    Replies: 4
    Last Post: 08-29-2012, 12:14 AM
  4. Add date OnChange Event - A to Z Walk Through
    By JeffG3209 in forum Programming
    Replies: 7
    Last Post: 08-12-2011, 04:40 PM
  5. Replies: 1
    Last Post: 06-22-2010, 03:15 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums