Solved

Double click field to see all the text in the field

Posted on 2014-09-05
2
229 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 34

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

912 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now