Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
Solved
selecting text
Posted on 2000-04-03
another one that has slipped by me please.
after an error is determined and I have setfocus back into the box I want to select all the text in that box so the user can renter it.
TIA
Craig
after an error is determined and I have setfocus back into the box I want to select all the text in that box so the user can renter it.
TIA
Craig
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
2-
2
- +3
10 Comments
Try this:
Private Sub Text1_GotFocus()
' Select all text
Text1.SelStart = 0
Text1.SelLength = Len(Text1.Text)
End Sub
Regards,
Grant.
Private Sub Text1_GotFocus()
' Select all text
Text1.SelStart = 0
Text1.SelLength = Len(Text1.Text)
End Sub
Regards,
Grant.
Private Sub Text1_LostFocus()
If Not (IsNumeric(Text1.Text)) Then
MsgBox "Please enter only a number"
Text1.SetFocus
Text1.SelStart = 0
Text1.SelLength = Len(Text1.Text)
End If
End Sub
If Not (IsNumeric(Text1.Text)) Then
MsgBox "Please enter only a number"
Text1.SetFocus
Text1.SelStart = 0
Text1.SelLength = Len(Text1.Text)
End If
End Sub
Skip99
I do not see how your code is any different than the other comments. If the question has already been answered as a comment, the questioner can accept a comment as answer. Since your "answer" is not unique, you have the option to "withdraw" your proposed answer.
I do not see how your code is any different than the other comments. If the question has already been answered as a comment, the questioner can accept a comment as answer. Since your "answer" is not unique, you have the option to "withdraw" your proposed answer.
Friends. Skip99 and Erick37. Both of u gave correct answers but correct me if i am wrong. The set focus should come last in the line of coding.Right?
Like This:
Text1.SelStart = 0
Text1.SelLength = Len(Text1.Text)
Text1.Setfocus
<Smiling> csindorf. To whom u r gonna award points. <Smile>
Like This:
Text1.SelStart = 0
Text1.SelLength = Len(Text1.Text)
Text1.Setfocus
<Smiling> csindorf. To whom u r gonna award points. <Smile>
csindorf stated that he already set focus back to the box, so all that was left was to select the string
text.sellength = len(text.text)
text.sellength = len(text.text)
Featured Post
Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Introduction
While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC. I didn't post completely correct code o…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.
 What are they?
An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Suggested Courses
Course of the Month5 days, 1 hour left to enroll
670 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.