Results 1 to 5 of 5
  1. #1
    tweety is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Nov 2012
    Posts
    126

    go to next field

    hi

    if i want go to next field after i changed the value how and where do i set it?

    its easier for the end and saves them from clicking and pressing the tab key



    thanks in advance

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Must press tab or enter key to cause movement to next field/control. Or use code in control AfterUpdate event to set focus to another control.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    tweety is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Nov 2012
    Posts
    126
    thanks for that

  4. #4
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    There's two ways to do this, but they both require that the Control being exited always has a predefined number of characters, such as telephone numbers, Social Security numbers, ID Number, etc.

    If the Control also has an Input Mask set (which I never do, IMs being more trouble than they're worth, IMHO) you can set its AutoTab Property to 'Yes,' and once the Input Mask has been complied with, the Focus will move to the next Control in the Tab Order.

    Without an Input Mask set, you can use some code to advance to another Control, once the required number of characters have been entered:

    Replace X with the required length of the data in the OriginalTextBoxName and NameOfNextControl with the name of the next Control to gain Focus.

    Code:
    Private Sub YourTextBoxName_Change()
      If Len(Me.YourTextBoxName.Text) = X Then NameOfNextControl.SetFocus
    End Sub


    But keep in mind, both of these methods will only work if the number of characters in the original Textbox is always fixed.

    Linq ;0)>

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Ooops, I forgot about AutoTab with InputMask. I have used InputMask with success but never set AutoTab. Users are required to Tab or Enter to commit entry.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Excel Import field truncation problem (to Access Memo field)
    By jhrBanker in forum Import/Export Data
    Replies: 6
    Last Post: 07-27-2012, 08:52 AM
  2. Replies: 8
    Last Post: 04-13-2012, 12:25 PM
  3. Replies: 16
    Last Post: 04-11-2012, 10:56 AM
  4. Replies: 1
    Last Post: 03-03-2012, 10:17 PM
  5. Replies: 1
    Last Post: 02-20-2012, 01:59 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