Record displaying dimensions

[drimades]

I've used the Access "Create form" wizard to create a tabular form that displays records from an Access DB. The size of the displayed textboxes doesn't fit all the contents.
How can I change the dimensions of the textboxes so to view all the contents?

 

[Crowley16]

erm...

have you tried going into the design mode of a form and dragging the side of the text box?

--------------------
Procrastinate Now!

 

[Remou]

Open the form in design view.

 

[drimades]

I can't use dragging the side of each box any time I have to display records. I don't know apriori the length of the text. Is there a way to autosize boxes so to fit the contents?

 

[Eupher]

drimades,

You should have some idea of the upper limit. What is the field size for the field in the form's table? Textboxes on forms are usually designed to handle the maximum desired text; if the field is larger than can practically/aesthetically be handled, then usually the control is created with a larger vertical dimension (to display multiple lines of text), with scrollbars enabled so the user can scroll through the text as needed.

Within reason, you can dynamically resize controls at runtime based on their contents. But YOU would have to design the VBA code to size the controls according to your criteria. There is no built-in property that will automatically resize a form control based on the length of its contents.

There is the Can Grow property, which applies to certain types of controls on forms and reports, and which resizes the vertical dimension of a control as needed. But for forms, this only applies when the form is printed, not when viewed onscreen.

HTH,

Ken S.

 

[missinglinq]

Have a look at Stephen Leban's CanGrow demo db that provides that kind of capability for forms!

http://www.lebans.com/cangrow.htm

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[Remou]

There are some rough guides, for example:

- You will probably require an address to fit in a window envelope.
- I seem to recall that 40 characters will suit for most names, 20 for given name, 20 for family name.
- 80 characters will suit for most email addresses.

And so on. I am not suggesting such guides as field sizes, but a little research can help to set a sensible length for a textbox. Finally, Shift+F2 will open a pop-up form (zoom) that will allow you to see the whole of a field or control.

 

[TheAceMan1]

How are ya drimades . . .

Also bear in mind:

[blue]There's no law that saids a record in a continuous form is limited to one line! [/blue]

If necessary you can add lines as needed. . . . Just expand the detail area!

See Ya! . . . . . .