Adjusting the Height of a Form

[wilderfan]

I have created a form that includes a number of text boxes. Half of these text boxes are unbound. They are visible to the end user for inputting data. The other half of the text boxes are bound, but invisible.

Through the use of VBA code, the data input into the unbound text boxes is later "transferred" into the bound or "real" text boxes.

All of the text boxes are in the Detail section of the form.

QUESTION: Does anyone know how I can reduce the height of the Detail section so that the space occupied by the bound / invisible text boxes does not result in a lot of wasted space when opening the form in Form View?

I have tried to adjust the height of the Detail section, but I can only reduce it so far. ACCESS seems to want to keep the Detail section large enough for ALL of the text boxes, even the text boxes that are invisible to the end user.

 

[boblarson]

If the bound boxes aren't ever being seen, move all of the hidden text boxes up to the top left corner and stack them. That way you can move the detail section up to only those that are displayed.

 

[wilderfan]

Thanks, Bob. I'll try the stacking method.


- - Robert

 

[DCrake]

Another way is to use the view form header/footer option and place all the unbound controls in either section and make the section invisible. That way you can space them out as you wish and are easier to get to if needed. Stacking them makes it difficult to manage them easily.

David

 

[wilderfan]

Thanks, David.

I'll give that a try.