Access 07 Level 100 Question

[WSR]

In Form Layout (or Design) View how do I change the width of just one set of
data and not adjust the remaining columns below it.

In other words, how do I select just the row of data to resize it
independent of the rest of the fields on the form?

Thanks

 

[Douglas J. Steele]

Assuming you're talking about a continuous form, you can't.

 

[Albert D. Kallal]

In Form Layout (or Design) View how do I change the width of just one set
of data and not adjust the remaining columns below it.

In other words, how do I select just the row of data to resize it
independent of the rest of the fields on the form?

Thanks

Perhaps you talking about control layouts? Click anywhere on a form text box
(when in design mode).

You will then see a "+" appear in the upper left. click on that, and then
all controls will highlight.

Now, click on the "arrange" tab, and you see Tabular, Stacked, Remove.

You want to click on "remove" to remove the grouping. Once done, then all
controls can be sized and moved independent of each other.

While sometimes as in your case you don't want the controls grouped, it one
of my favorite new features in ms-access.


This feature is demostarted here:
http://office.microsoft.com/en-ca/access/HA102765511033.aspx

 

[WSR]

Albert.

That is why you are an MVP!

Thanks!

Perhaps you talking about control layouts? Click anywhere on a form text
box (when in design mode).

You will then see a "+" appear in the upper left. click on that, and then
all controls will highlight.

Now, click on the "arrange" tab, and you see Tabular, Stacked, Remove.

You want to click on "remove" to remove the grouping. Once done, then all
controls can be sized and moved independent of each other.

While sometimes as in your case you don't want the controls grouped, it
one of my favorite new features in ms-access.


This feature is demostarted here:
http://office.microsoft.com/en-ca/access/HA102765511033.aspx