Paste Special should format the size of a gridline

[ccspace]

When I'm working in Design view of a report in Access, I format the font and
choose paste special to copy the format to another text box. I would like to
also paste the format of the box (the size of it) One can format the
font-color, etc.-but I also need to resize the size of the text box. For
this task, I have to resize one text box at a time. It would be grea if with
one click I could copy the format of the font, color, etc,and the size of the
text box.
To make a long story short, one would format one text box-color, etc, resize
the text box to fit the amount of tex-and then click the paste special brush.
The paste special brush would copy not only the font style, color, size, but
it would also resize the text box to the same size as the source. It would
save a lot of time.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...45c&dg=microsoft.public.access.tablesdbdesign

 

[John Vinson]

For
this task, I have to resize one text box at a time.

Not really.

Ctrl-click all the textboxes you want to resize. On the menu select
Format... Size... To Widest, Format... Size... To Tallest.

Then (with them all selected) use the mouse to select the lower-right
corner and resize to whatever size you wish.

John W. Vinson[MVP]