Textbox dbl click resize

[air1access]

I have a bound form with quite a few textboxes... I was wondering if it is possible for the user to dbl click a textbox and to have the textbox expand (height) to show the value of the textbox, then dbl click again to bring it back to its original size. There are a few textboxes that are memo fields, and the value in the textbox is huge. So this would allow the user to see the entire value/entry... As well as keep the form not so busy & fit all of the data on the form...

Any suggestion or examples...??
Thanks in advance..!!
air1access

 

[SgtJarrow]

I would not suggest that method. I would find that a disturbing effect and I would think my users would as well.

As an alternative, I would recommend creating a "memo field edit" form. Using the double-click event, open this form as a dialog and copy the text from the textbox into it. The users then edit this box and click a close button (or the X if you use the onclose event or something similar). The close button puts the new text back into the original textbox.

There are several ways to work with the moving of the text back and forth...so if you get stuck, let me know and I will help you figure it out.

Just my couple of pennies...

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB.NET Programmer

 

[Remou]

You can use zoom in the double-click:

DoCmd.RunCommand acCmdZoomBox

Or just press Shift+F2