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
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
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.
thanks for that
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)>
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.