Form wrap text (1 Viewer)

Gismo

Registered User.
Local time
Today, 15:01
Joined
Jun 12, 2017
Messages
1,298
Hi all,

I have a few controls in a form but one could be quite larges in some circumstances, i dont want to have the control big enough to fit all in that field if most records will only be a few words. i just can not get the control to grow or shrink or to wrap the text should the amount of data is quite substantial. any help would be much appreciated
 

Ranman256

Well-known member
Local time
Today, 09:01
Joined
Apr 9, 2015
Messages
4,339
what controls? Textbox works great for this.
 

Gismo

Registered User.
Local time
Today, 15:01
Joined
Jun 12, 2017
Messages
1,298
it is a textbox but can not get the text to wrap or expand the field for that one large text, keep on cutting off on the right
 

Minty

AWF VIP
Local time
Today, 13:01
Joined
Jul 26, 2013
Messages
10,355
The can grow property only works on print of a form and should really be restricted to a report property.

You can get around this by displaying a report in the form , provided you don't want to edit the data in the form. it will then expand and shrink as you require e.g.
 

Attachments

  • ReportOnForm.jpg
    ReportOnForm.jpg
    87.7 KB · Views: 430

Gismo

Registered User.
Local time
Today, 15:01
Joined
Jun 12, 2017
Messages
1,298
The data must actually updated so the report on form will not work for me
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 09:01
Joined
May 21, 2018
Messages
8,463
For most of my memo fields I have a zoom feature to pop up an editable zoom box. I usually do that off of a double click in the cell. I do not use the built in zoom feature since it is very limited.
 

missinglinq

AWF VIP
Local time
Today, 09:01
Joined
Jun 20, 2003
Messages
6,423
Maybe something like this:

Code:
Private Sub YourControlName_DblClick(Cancel As Integer)
  DoCmd.RunCommand acCmdZoomBox
End Sub
Linq ;0)>
 

Users who are viewing this thread

Top Bottom