enlarge field with a click (1 Viewer)

rainbows

Registered User.
Local time
Today, 04:35
Joined
Apr 21, 2017
Messages
425
hi , i have a form with 4 "long text " fields so i dont have to enlarge the test boxes in my form is it possible to click on that field to see and write all the text
for example Approved actions


thanks steve

1646379507599.png
 

Minty

AWF VIP
Local time
Today, 12:35
Joined
Jul 26, 2013
Messages
10,367
Use the zoom box feature. Shift & F2 will bring it up manually or use

DoCmd.RunCommand AcCmdZoomBox

On the double click event to automatically open it from the form if the user double clicks.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 19:35
Joined
May 7, 2009
Messages
19,227
if you press Shift-F2, there is a Zoom box.
(too slow).
you can create your own if you like.
 

Attachments

  • ZoomTexBox.accdb
    1.2 MB · Views: 148

SHANEMAC51

Active member
Local time
Today, 14:35
Joined
Jan 28, 2022
Messages
310
hi , i have a form with 4 "long text " fields so i dont have to enlarge the test boxes in my form is it possible to click on that field to see and write all the text
for example Approved actions
what is the maximum length of the text
1- if up to 1000 characters and 1 paragraph, then you can highlight it in a new window for correction
2- if the text is longer or several paragraphs, then I prefer a subordinate table (the fields can also be by, but it is more convenient to adjust the line for each paragraph)
---
I have met memo up to 11,000 characters, a paragraph of 5000
is difficult to correct them with one field, it is virtually impossible
 
Last edited:

Eugene-LS

Registered User.
Local time
Today, 14:35
Joined
Dec 7, 2018
Messages
481

Attachments

  • Enlarge controls with long text v02.zip
    118.9 KB · Views: 133
  • Enlarge controls with long text 00.png
    Enlarge controls with long text 00.png
    58.6 KB · Views: 142
  • Enlarge controls with long text 01.png
    Enlarge controls with long text 01.png
    60.1 KB · Views: 132
  • Enlarge controls with long text 02.png
    Enlarge controls with long text 02.png
    59.3 KB · Views: 137

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 19:35
Joined
May 7, 2009
Messages
19,227
another modified zoombox.
 

Attachments

  • ZoomTexBox.accdb
    508 KB · Views: 155

SHANEMAC51

Active member
Local time
Today, 14:35
Joined
Jan 28, 2022
Messages
310
One more example :
I use it quite often.
the pink zone is a zone for filters for each field (there are 12 of them here), according to the format of the fields, strictly above the fields
, the yellow zone is closed from accidental damage
, the green zone is the zone of the active memo field, for correcting or viewing notes that can be rendered in a subordinate form, then only viewing is here
 

Attachments

  • u_memo0304.png
    u_memo0304.png
    65.2 KB · Views: 136

Pat Hartman

Super Moderator
Staff member
Local time
Today, 07:35
Joined
Feb 19, 2002
Messages
43,196
If you teach the user how to use the zoom box, no code is required. If you want to bring up your own zoom box, you need to use the double-click event and either open the zoom with code or open your own custom form and that requires code in every single control where you want to use your custom zoom. I give the customer a choice. Pay me to code or use the free functionality.
 

rainbows

Registered User.
Local time
Today, 04:35
Joined
Apr 21, 2017
Messages
425
Gentlemen , i would like to thank you all so many different ways to do it . i am going to take a copy of my database and try them all just to try and learn how they all work amazing

thank you steve
 

Users who are viewing this thread

Top Bottom