Access DB question?

Question

I have an access database with some tabs with sub-forms.

Is there an easy way to make all of the subforms the same size?

Answer 1

The easiest way would be to go into the properties of each of the subforms (when in the form design view) and set the height and width all the same.

Adjust one of the subform controls so that it's the size you want. Then right-click, go into Properties, and copy the height and width properties (in the Format tab) and paste them into a text editor like Notepad (to store them so you can copy and paste them again). You might also want to copy the left and top properties, if you want all subforms to be located in the same place in the tab.

Then, for each of the subforms that you want to set, select the subform control, go into Properties, and paste the height and width (and, again, possibly the left and top) properties from Notepad, so that the current subform has the same width and height as the first one. Then do the next, and the next...

There's also the possibility to set the properties of a bunch of controls at once, by Shift-clicking, but you said that these subforms were in different tabs, so I doubted that would work for your purposes.

Answer 2

hey check http://msaccess.batcave.net