Solved

Double click field to see all the text in the field

Posted on 2014-09-05
2
231 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 35

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

Suggested Solutions

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
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…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

809 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