Form Design in Columns

Hi Experts,

i have designed a form which is shown below in first picture. The numbers come in one single row.

Can someone help me show it in 3 columns like shown in second picture.

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.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Is this in Access?

If so, just open the form in Design view, and move your controls around until you get the format you desire.
Rey Obrero (Capricorn1)Commented:

the default view if the form must be Single form

in the design view of the form, just drag the controls to where you want them to appear, save the form
SaichandAuthor Commented:
if the default form view is single it would only show me one record and not all the report that meet the criteria as in continuous forms
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

Rey Obrero (Capricorn1)Commented:
upload a copy of the db
SaichandAuthor Commented:
attached is a copy.... i am still working on the combo box selection...
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Even in a Continuous form, you simply rearrange the controls to the arrangement/layout you want.

Open the form in Design view, and use your mouse to drag the controls where you want.

Rey Obrero (Capricorn1)Commented:
test this

post back your comments

SaichandAuthor Commented:
i want only the jurisdiction code column to show in columns and not the other
SaichandAuthor Commented:
LSMConsulting: Can you please show it in the attached database?

my question is how will i show the same field in column view
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Move the controls out of the Form Header. That section should only be used to show data which is relevent to ALL records.
SaichandAuthor Commented:
are you talking about the combo box?

the selection there is relavent to all records in the details section.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I have no idea where you're heading with this.

The Header section of the Form should be used to show ONLY those records which are relevant to ALL Records in the Detail section.

If you want your form to look like the image you show in your second image, then move ALL controls to the Detail section.

SaichandAuthor Commented:
i have a test db attached in my previous post... can you show me in it what you are saying?
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
As I said:

Move the controls from the HEADER section of the form to the DETAIL section of the form. I'm not going to do it for you - this is a very, very basic task and I'd encourage you to try it on your own:

1) Open the form in Design view
2) Select ALL the control in the Form's Header
3) Hover your mouse over one of those controls (Access will "group" them for you, so dragging one will drag the group).
4) Click and HOLD the left mouse button and drag them down to the Detail section, and Drop them in the Detail section.
5) Move the controls to the location desired, but KEEP them in the Details section.
SaichandAuthor Commented:
i did as instructed and still need help to get the desired result. Attached is a copy of the db.
It is impossible to have multi column form, but it is possible to emulate it.

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
SaichandAuthor Commented:

i have a couple of questions.

1) In the attacehed database, where did the table Emp1 get created.
2) Its not showing right for state selection of DA.
3) When selecting the jurisdiction i dont get the desired result on the form.

But i should say, your help on this is highly appreciated.
SaichandAuthor Commented:
thanks a lot als315...... your suggestion on creation of multi column helps...
SaichandAuthor Commented:
I figured it out myself, but use the logic given by this individual.
SaichandAuthor Commented:
als315: can you still help me with the second question posted above. as we are populating values on the mainform using multiple subforms... in case of certain states the information comes in the 2 or 3 text box instead of the first one...
1. It is created inside query
This is example with corrected 2 & 3
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.