?
Solved

How do you individually resized an Access 2007 form field?

Posted on 2009-04-30
7
Medium Priority
?
531 Views
Last Modified: 2013-11-28
In Access 2003 I could easily select & resize form fields.  They all resize in Access 2007.  How do I break the connection between fields so I can size them individually so I can place them on the same horizontal row if I like?
0
Comment
Question by:leslieinva
  • 4
  • 3
7 Comments
 
LVL 15

Expert Comment

by:MYCU
ID: 24271489
In Access 2007 you need to click on the Arrange tab - select auto format -  select none.
Once you do this you may need to go back in and change your colors, but you will now be able to resize and move things that were once docked to the form.

Good uck!
0
 

Author Comment

by:leslieinva
ID: 24271731
I found the AutoFormat, but where is the None value? I droped the AutoFormat & saw a lot of formats, but non "None"
0
 
LVL 15

Expert Comment

by:MYCU
ID: 24271766
Sorry about that. Once you click on AutoFormat click on the AutoFormat wizard and a list of formats will come up. Select "None" from that list.
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 

Author Comment

by:leslieinva
ID: 24271886
I selected None in the Autoformat wizard & all my fields are still resize at the same time.  I can't resize just one.
0
 
LVL 15

Accepted Solution

by:
MYCU earned 1500 total points
ID: 24271934
If that still doesn't work go to the arrange tab, highlight the text boxes or labels in question, and click on the Remove button under the Control Layout options.
0
 

Author Comment

by:leslieinva
ID: 24272083
I had to select the little + to the left of all the controls before I do the remove.  That worked finally.
0
 

Author Closing Comment

by:leslieinva
ID: 31576499
I had to click on the + selector instead of the actual text box before I could remove the AutoFormat.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question