Resizing controls Access 2013

Folks,
I have a form with three controls. I need to re-size them individually and I know that is possible, but I've just forgot how.
Frank FreeseAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

hnasrCommented:
You can use the controls properties to accomplish that.

Example to change the width of a field:
field1.Width = 1000   ' sets the width to 1000 twips
field1.Width = field1.Width - 100 ' decreases the width

Actual code depends on what you want to achieve.
0
Frank FreeseAuthor Commented:
I remember vaguely that if the controls were not grouped they could be resized and moved independently from one another. That's what I'm trying to do. I'm not trying to mange the controls with VBA, just in design mode.
0
Robert ShermanOwnerCommented:
In design view, if the controls are not grouped, it should just be a matter of single-click to select a control, at which point the control will become "active" and will have anchor handles at its corners and sides.   Click and drag any of those handles to resize.   Is this different from what you're experiencing?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Robert ShermanOwnerCommented:
Also, if more precise control over control size is needed, selecting any control in design mode and then bringing up its properties will allow you to express numerically how things should be sized by changing values on the "Format" tab such as Width, Height, Top, Left.
0
hnasrCommented:
Comments are based on our assumptions when the question is short.

If you supply a demo database, then a better answer can be achieved.
I am not sure why the resizing of a control, while in design view, is posing a problem.

Here is another way, and it may expose a hidden problem:

Open form, assume name is Form1 and fields f1, f2, and f3

Open code editor and type, In Immediate window:
forms!form1!f1.width=1000
forms!form1!f2.width=1000
forms!form1!f3.width=1000

Open in new window

'or you can use this format:
Form_form1!f1.Width = 1000
Form_form1!f2.Width = 1000
Form_form1!f3.Width = 1000

Open in new window

You may use other similar statements to control other properties.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
If the controls are grouped then I don't think you can size them individually. You can "ungroup" them by selecting the Group, and then click "Remove Layout" on the Arrange tab. Otherwise, resizing the "control" actually resizes the "group".
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Frank FreeseAuthor Commented:
There you go Scott - I now recall what I needed to do.
Thanks to everyone else also
0
Robert ShermanOwnerCommented:
@Scott: good answer and something I wasn't even aware of in the more recent versions of Access..    I just wanted to add that there appears to be some difference between what I would have, up until now, just called "grouped" controls and what these are, which is more like "controls in a layout".  

I'm looking at Access 2010 at the moment, so this may have changed even further for 2013 which I don't have in front of me right now.   In 2010, there is still the classic concept of grouping controls -- though it is in a strange place under "size/space" in the "Sizing & Ordering" group.   Controls "grouped" that way would still require you to "ungroup" them from the same ribbon location and the "Remove Layout" in that case is not an available option.  

I realize the question specifically states Access 2013, but just figured I'd add this bit of info for anyone still stumped by a "group" or "layout" of controls that might be using 2010.   Perhaps this confusing group vs. layout issue has been improved in the 2013 version...
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Robert: Yes, there is a distinction between traditionally "grouped" controls, and controls in a Layout Grid. As you mention, if the controls are "grouped" the Remove Layout button is disabled, and if the controls are in a Layout Grid, the Group/Ungroup buttons are disabled.

So yes, there is some confusion and terminology mish-mashing in this area. I've seen it before, hence the reason the details of the question tickled my (few remaining) brain cells.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.