Customised width and height of Control on a Form

[reddevil1]

I have been searching for a way to customise the height and width of a Control when I drag and drop it onto my Form.

Is there such a setting rather than the standard MS setting?

 

[Catalina]

In Design View you can drag the edges to the desired position.
Or in Properties of the Control you can set the dimensions and position.

Catalina

 

[reddevil1]

Yes, I understand the controsl are re-sizeable. But I was wondering if they could be 'dragged' onto the Form already to the required size of my database?
I want them to fit snugly into a Box.

 

[Catalina]

Not that I know of.

 

[nanscombe]

Copy and paste from one you prepared earlier?

 

[reddevil1]

could do.
but with more than 50 fields per form, it would take a long time to change the Control Source of each text box?

 

[nanscombe]

I actually do tend to copy and paste.

Size one and roughly position. Copy and paste = 2.
Select all, copy and paste = 4.
Select all, copy, paste and use the align tool to align them horizontally = 8.
Select whole row, copy and paste = 16.
Roughly position 2nd row.
Select both rows, copy and paste = 32.
Paste again = 48.

Then I select each column of items in turn and use the align tool to align to line them up.

Naming and Control Sources? Yes, that is tedious but with years of practice it gets reasonable quick.

Mind you, you can actually select multiple controls and make them all the same size, ie Fit to Widest, Narrowest, Tallest, Shortest.

Failing that, select multiple controls and simply change the width, height etc in the Property form.

Although I've not used it, the new Layout mode (compared to Access 97) may give you more control.

 

[reddevil1]

and here is how to do it easily...

Select the Textbox icon in the Toolbox (Acess 2003) or onthe Controls group of the Design Ribbon (Access 2007 and later).
The title of the Properties box reads "Default Text Box".
Set the properties that the new text boxes (and other controls) that they should inherit.

Any drag and drop controls will inherit these properties on that particular Form.

Viola!