Solved

Form Design in Columns

Posted on 2011-03-01
22
298 Views
Last Modified: 2012-05-11
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.

Test
Thanks,
Sai.
0
Comment
Question by:Saichand
  • 11
  • 5
  • 3
  • +1
22 Comments
 
LVL 84
Comment Utility
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.
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility

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
0
 

Author Comment

by:Saichand
Comment Utility
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
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
upload a copy of the db
0
 

Author Comment

by:Saichand
Comment Utility
attached is a copy.... i am still working on the combo box selection...
test.accdb
0
 
LVL 84
Comment Utility
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.

0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
test this

post back your comments

test.accdb
0
 

Author Comment

by:Saichand
Comment Utility
i want only the jurisdiction code column to show in columns and not the other
0
 

Author Comment

by:Saichand
Comment Utility
LSMConsulting: Can you please show it in the attached database?

my question is how will i show the same field in column view
0
 
LVL 84
Comment Utility
Move the controls out of the Form Header. That section should only be used to show data which is relevent to ALL records.
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 

Author Comment

by:Saichand
Comment Utility
are you talking about the combo box?

the selection there is relavent to all records in the details section.
0
 
LVL 84
Comment Utility
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.

0
 

Author Comment

by:Saichand
Comment Utility
i have a test db attached in my previous post... can you show me in it what you are saying?
0
 
LVL 84
Comment Utility
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.
0
 

Author Comment

by:Saichand
Comment Utility
i did as instructed and still need help to get the desired result. Attached is a copy of the db.
test.accdb
0
 
LVL 39

Accepted Solution

by:
als315 earned 500 total points
Comment Utility
It is impossible to have multi column form, but it is possible to emulate it.
DB26856243.zip
0
 

Author Comment

by:Saichand
Comment Utility
ok.

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.
0
 

Author Comment

by:Saichand
Comment Utility
thanks a lot als315...... your suggestion on creation of multi column helps...
0
 

Author Closing Comment

by:Saichand
Comment Utility
I figured it out myself, but use the logic given by this individual.
0
 

Author Comment

by:Saichand
Comment Utility
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...
0
 
LVL 39

Expert Comment

by:als315
Comment Utility
1. It is created inside query
This is example with corrected 2 & 3
DB26856243.zip
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

771 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now