De-Highlight Unbound Text Box dbarmer 12/3/2008 8:03:52 PM I have an unbound text box that I use on a form that updates text to it as code progresses in VBA. It updates the user what the program is doing. It works well, however, I can't seem to get the "highlight" off the text. Is there a way to get that insertion point at the end of the text - in the unbound text box, or at least not highlight at all...

Re: De-Highlight Unbound Text Box "Dirk Goldgar" <dg[ at ]NOdataSPAMgnostics.com.invalid> 12/3/2008 8:24:45 PM "dbarmer" <dbarmer[ at ]discussions.microsoft.com> wrote in message news:DD29FA36-5F9B-4043-9E6E-13CE916C09CE[ at ]microsoft.com... [Quoted Text] >I have an unbound text box that I use on a form that updates text to it as > code progresses in VBA. It updates the user what the program is doing. > It > works well, however, I can't seem to get the "highlight" off the text. Is > there a way to get that insertion point at the end of the text - in the > unbound text box, or at least not highlight at all... How are you updating this text box? What code are you using? If you are setting the focus to the text box -- maybe to set its Text property -- you almost certainly probably don't need to be doing it. You can set the control's Value property without giving it the focus. If you really have to give the text box the focus, you can set its SelLength property to 0 whenever you do that, to de-select the text. However, I have an alternative suggestion: If the text box is not to be updatable by the user, but is just used to display text you put there, why not use a label control instead? You can change its Caption property on the fly, just as easily as setting the value of a text box, and a label control can't get the focus and never highlights the caption text. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup)

Re: De-Highlight Unbound Text Box "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_gmail.com> 12/3/2008 8:42:35 PM With Me!MyTextbox .SetFocus .SelText = .SelLength End With -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "dbarmer" <dbarmer[ at ]discussions.microsoft.com> wrote in message news:DD29FA36-5F9B-4043-9E6E-13CE916C09CE[ at ]microsoft.com... [Quoted Text] >I have an unbound text box that I use on a form that updates text to it as > code progresses in VBA. It updates the user what the program is doing. > It > works well, however, I can't seem to get the "highlight" off the text. Is > there a way to get that insertion point at the end of the text - in the > unbound text box, or at least not highlight at all...

Re: De-Highlight Unbound Text Box dbarmer 12/3/2008 10:29:32 PM Thanks Douglas, That worked like a charm!.... Question: I update the display text about 10 or so times. Instead of repeating that code over and over, do you think it will work okay if I use a gosub for that procedure with variables? P.S. Since I open this form on top of another I had to change the "ME." to FORMS!.... formname, textbox - But it worked fine once I did that! "Douglas J. Steele" wrote: [Quoted Text] > With Me!MyTextbox > .SetFocus > .SelText = .SelLength > End With > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no e-mails, please!) > > > "dbarmer" <dbarmer[ at ]discussions.microsoft.com> wrote in message > news:DD29FA36-5F9B-4043-9E6E-13CE916C09CE[ at ]microsoft.com... > >I have an unbound text box that I use on a form that updates text to it as > > code progresses in VBA. It updates the user what the program is doing. > > It > > works well, however, I can't seem to get the "highlight" off the text. Is > > there a way to get that insertion point at the end of the text - in the > > unbound text box, or at least not highlight at all... > > >