I have a couple of textboxes on a form. When I enter a number in the first textbox and press enter the rest of the textboxes are filled with data to view the data. The focus then jumps to the next textbox. I want the focus to always stay in the first textbox not jump to the next textbox.
How can I get the focus to stay in the first textbox when I press enter key?
Use
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
At the end of code set focus to same textbox
Formula:
Please Login or Register to view this content.
I tried that and it didn't work (but I will try again). I have a sub that is run from the AfterUpdate event (of the textbox where I want the focus to stay) that populates the rest of the textboxes.
Where would I put the TextBox1.SetFocus?
I tried the Exit event of the textbox where I want the focus to stay.
I tried the AfterUpdate event of the textbox where I want the focus to stay.
I tried it as the last statement of the sub that is called that populates the textboxes.
I even tried it in the Enter event of the next textbox where the focus goes when I press enter.
None of the above worked. The focus still went to the second textbox for the first three options I tried. For the fourth option the focus went to the third textbox.
Suggest you post a sample workbook.
If both the .MultiLine property of a textBox and the .EnterKeyBehavior are True, pressing Enter will add a linefeed to the text in the box.
If either is False, Enter will move the focus to the next control in the tab order.
If you want a text box to completely ignore the pressing of the enter key, you could add this to the user form's code module
Another approach would be to put your Fill-Other-Boxes code in the BeforeUpdate event and set Cancel to TruePlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by mikerickson; 10-09-2016 at 01:12 PM.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
I don't want to disable the Enter key. This is used to fire the search e.g user type 1234 Enter and the code finds entry 1234 and displays the details.
Your second suggestion of setting Cancel = True makes the textbox behave exactly as I want but then I'm stuck in the textbox. Can't exit the textbox if the user clicks the Cancel button when done viewing entries.
Hi,
Depending upon which event you are using to populate the other textboxes, you might simply set the Tabstop property of the other controls to False.
Don
Please remember to mark your thread 'Solved' when appropriate.
Again, suggest you post a sample workbook so we can test potential solutions.
Attached a sample workbook.
It does not help to make the TabStop properties false for all the fields. It just sets the focus to the Cancel button then.
Find_Journal function does not work (disabled the code) as it references data in a huge workbook but you will get the idea.
I want the focus to stay in the TxtJournalNumber textbox when entering a journal number in the TxtJournalNumber box and pressing Enter. Not jump to the next textbox.
You might use the KeyDown event rather than the BeforeUpdate
Please Login or Register to view this content.
Thanks xlnitwit. It now works exactly as I wanted. Thanks again.
p.s. Wanted to add to your reputation but forum won't let me
Then set the .TabStop of that control to False also.Originally Posted by Bezzie
From what I can see from that code, you don't really need text boxes (other than the one). Unless you anticipate the user entering into the control, a Label control would serve you as well as the secondary text boxes.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks