Solved

Double click field to see all the text in the field

Posted on 2014-09-05
2
232 Views
Last Modified: 2014-09-05
Is it possible to be able to double-click a text field on a form and somehow have the text in that field popup so the user can read all of the text?  The fields on the form are too short and can't be lengthened due to space limitations.
0
Comment
Question by:SteveL13
2 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 40305950
Simplest would be to call the built-in zoom box.  In the double click event do:

    RunCommand acCmdZoomBox

Or teach them to use Shift/ F2.

Jim.
0
 
LVL 36

Expert Comment

by:PatHartman
ID: 40305992
No points please -- I teach them to use shift/F2.  It's like the teach a man to fish parable.  If I code the action, I have to do it EVERYWHERE and if they find a place I didn't code it, they're unhappy.  If I teach them the built in shortcut, I don't have to code ANYTHING.  I also want to use double-click in many places to drill down and so that is a conflict.  It would be confusing for people to have double-click mean open the zoom box in some places but drill down in others.  And horror-of-horrors, what if you want to do both for the same control?

If you elect to code the action, I would suggest building your own zoom box so you can make it sizable.  The zoom box is certainly useful but it would be much more useful if it were not size constrained.
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question