473,403 Members | 2,270 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,403 software developers and data experts.

Spacing of Fields on Access2007 forms

When creating forms using Access2007, if I draw fields from a query, table, etc. such that it is a bound field, I find it difficult to insert an unbound field between them in the design view. Played with padding in Properties. Is there a property that keeps those fields together?
Looking for a way of "undoing" formatting, inserting new fields, shifting the fields around, and then reinstating WITH the newly inserted unbound field.
Mar 7 '12 #1
2 1550
Mihail
759 512MB
After the form is created switch to Design View and click somewhere in form's area.
Press CTRL + A . This will select all controls in form.
Switch to Arrange tab (ribbon)
Under Control Layout section you will find the Remove button.
Click this and you will be able to (re)arrange controls as you wish.
Mar 7 '12 #2
Thanks Mihail. You got me on the right track.
I just selected the fields that I wanted "to release" and then hit the REMOVE button.
Found the "answer" to the 2nd aspect of my question: "reinstating the FORM aggregation of the fields in the same area.
Again, selecting the fields that you want [CTRL+A for all fields, SHIFT + fields desired for JUST the fields selected]; and then
Selecting "Stacked" or "Tabular" seemed to aggregate them together (sort of the like the functionality of GROUP in PowerPoint).
Playing further with selecting fields, using combinations of "Remove", "Stacked or Tabular" and the "Control Padding", I've got back control of the creation of my form while being able to use the newer form creation tools. Thanks again for sharing your insight!!
Mar 7 '12 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Sven Seljom | last post by:
I want to take the value from one form-field, deduct the VAT and return the value in another form-field. I have made a Public Function for this and attached it to the text-box. Can anybody help me...
1
by: Ren | last post by:
when I click on my field list the same table keeps coming up throughtout the database and it is not the table that I want to be in. How do I change to another? Ususally you can scroll in...
2
by: George Steward | last post by:
I have a form in which I only want certain boxes to show under certain conditions, for example, when a transaction is selected as "commission" I need to show the fields for entering the relevant...
1
by: John | last post by:
Hi How can I read the value of a field on a form A from a form B? Both forms A & B are open. Thanks Regards
0
by: George Sakkis | last post by:
Didn't have much luck in the Django list, so I'm posting it here just in case anyone has come up with this problem. Django maintains two parallel hierarchies of field classes, one related to...
1
by: Elainie | last post by:
I have two tables and two forms, "Patient Details", "Placement Details". In the "Patient Details" form, I have the name and addresses fields. I want to update the addresses fields automatically...
8
by: janeks | last post by:
I faced with problem in the subject. I need to dinamicaly create the recordset and show the results in a small subform. To construct and test the form I made following test code for form load...
4
by: minchazo | last post by:
Hello, I've been creating some forms recently in Access 2003 and using hidden textboxes quite a bit. As an example, the visible textbox CasesDone uses the DLookup function to sum the records in...
1
by: updw123 | last post by:
Hi there, Does anyone know if spam trawls can pick up email addresses from hidden fields in submission forms. And/or does anyone know if there is an alternative to having your email address in...
3
by: NigelD | last post by:
In Access 2007 I have two forms - one called Customers and the other called SWZ. There is no relationship between the two forms. The SWZ form has two fields Account Number and Application Number....
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.