Wrox Programmer Forums
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 6th, 2004, 11:24 AM
Authorized User
 
Join Date: Jun 2003
Posts: 75
Thanks: 0
Thanked 0 Times in 0 Posts
Default Expanded Text View

Hello,
   Does anyone know the API call or the technique to display all the text when the control/column isn't wide enough to see it all. I'm looking for the same functionality as the Explorer. Open Windows Explorer and make the folders column on the left side very narrow. Now hold your mouse over an entry under my computer that extends beyond the column width. Notice that a text window is displayed to show you the entry. That is the functionality I'm looking for. Any thoughts or ideas.

Thanks,
Mike
 
Old February 6th, 2004, 11:41 AM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Not tested, but you might try the following on the afterupdate event:

Code:
Me.ControlName.ControlTipText = Me.ControlName.Value
HTH,

Beth M
 
Old February 6th, 2004, 11:53 AM
Authorized User
 
Join Date: Jun 2003
Posts: 75
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Beth,
   Thanks for the reply. I thought of that, but control tip text is displayed to the right and lower from the mouse position. I need to have the cut off text become visible without being moved.

Thanks,
Mike
 
Old February 6th, 2004, 12:03 PM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Are talking about expanding (or can grow) type of action?
 
Old February 6th, 2004, 12:14 PM
Authorized User
 
Join Date: Jun 2003
Posts: 75
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Expanded...the actual text box/listbox column would not change, only the text is displayed. The same exact functionality that exists in windows explorer.
 
Old February 6th, 2004, 12:21 PM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

In Windows Explorer it pops up like a control tip except over the properties. I wonder if there is a way to designate the position of the control tip?
 
Old February 6th, 2004, 12:23 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Barring any API code, you can either set the ControlTipText the same as the textbox value, but you won't get it to display right where the text field is (it'll pop up where IT wants to); or the user merely presses SHIFT+F2 to open a zoom box and they can see everything (assuming the font in the zoom box is small enough).


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
 
Old February 6th, 2004, 12:27 PM
Authorized User
 
Join Date: Jun 2003
Posts: 75
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If I can control the location of the control tip text, then that would work. I will check into this.

I hoping for a non intrusive solution. The user wouldn't have to click, type to make it happen. Just by holding the mouse over the text, it would automatically display the missing text.

My gut feeling is that it will be an API call. First, you have to determine if any of the text is not visible and then display if necessary.

I've been looking at API's, but if you don't know what your looking for, it's hard to have the correct key words to search...LOL

Thanks again to all,
Mike
 
Old February 6th, 2004, 12:38 PM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Just one more thought on this Mike. You could put an oversized hidden label on the form behind the text box. On the mouse move event (in XP) for the text box, set visible = true for the label, visible = false for the text box and set the label's caption to the text box value.

But if you could do this using API, then that would probably be the best solution. Have you checked the mvps website?

Beth M
 
Old February 6th, 2004, 12:42 PM
Authorized User
 
Join Date: Jun 2003
Posts: 75
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Beth,
   Good call. I think that would work, a little more work that what I was looking for, also it would only work for text boxes. What about columns in a list box. I found a couple of API's, but not sure if they are what I'm looking for, the explanation of the API usage can be a little abstract. I was looking at Graystring and ExtTextOut on the microsoft website.

Thanks,
Mike





Similar Threads
Thread Thread Starter Forum Replies Last Post
Tigra Tree : Display As Expanded sreejipnr Javascript How-To 0 June 10th, 2007 07:23 PM
Convert special character for text view mussitsch Classic ASP Professional 0 October 26th, 2006 11:13 AM
View Text in HTML Format echovue Access 4 February 13th, 2006 02:00 PM
Forum expanded to Beginning PHP 5 jminatel BOOK: Beginning PHP4/PHP 5 ISBN: 978-0-7645-4364-7; v5 ISBN: 978-0-7645-5783-5 2 November 2nd, 2004 03:14 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.