Forms, Field resizing

J

Justrying

I'm trying to resize individual fields on a form but access keeps all the
fields grouped. I know there is a way to allow individual formating but I
can't remember it.
 
B

BruceM

Forms have controls that may be bound to fields in the underlying recordset
(if the form is bound). If you are using a continuous form or a datasheet
the controls in each column can be one size only. There are ways to format
depending on the field's contents and other factors, but AFAIK there can be
only one size. In a report a control can be allowed to grow or shrink
depending on the contents, but the size adjustment is vertical only.
In a single form you can use code to adjust the size of text boxes and other
controls as you move from one record to another.
If you are talking about something other than what I have described, please
be more specific.
 
M

MikeJohnb via AccessMonster.com

I think you refer to Access 2007, both forms and reports have fields that are
anchored together, if you change the size of one they all change. If that is
what you are refering to then this is how to split them.

With the form or report in design view. Drag over all the fields and labels
you want to be free so that they are highlighted. Select the arrange Ribbon.
Select Remove. fourth Icon from the left I think it is.

Once you have done that. the fields should be free of the anchors and you
should be able to move or size them independantly.

I hope this helps?

Regards

Mike B
 
M

MikeJohnb via AccessMonster.com

I of course meant Controls not fields as forms and reports have controls
where tables have fields. Just to be correct I guess, the essence of the
answer still applies.

Happy New Year All
 
A

Albert D. Kallal

Justrying said:
I'm trying to resize individual fields on a form but access keeps all the
fields grouped. I know there is a way to allow individual formating but I
can't remember it.
Click to expand...

I suspect you are using access 2007, and it has a new feature which allows
stacked, or so called Group controls. while this features an absolute huge
improvement over previous versions of access, especially when you're
designing reports, when you want to go back to familiar way of working with
text controls on a form, often it gets in the way.

When the form is in design view, simply click on any text box, and if you
get Orange borders around all the controls, then you've got a stacked or
Group set a control's. To un-group, click on the "+" signed that appears to
the upper left of the whole set of controls. Now, on the ribbion, select
the "arrange" tab, and you see Tabular, stacked, Remvoe.

Simply chosoe the "remove" option. Now, when you click on a contorl on
the form you Should be able to move things as before.

Once this is done,then controls can be moved around as before.

Learning how to use those stacked and Group controls in access 2007 is one
of the largest keys to obtaining a large improvement in product if it in
access 2007, especially when you're building reports.
 
Top