Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 360
  • Last Modified:

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.

Test
Thanks,
Sai.
0
Saichand
Asked:
Saichand
  • 11
  • 5
  • 3
  • +1
1 Solution
 
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.
0
 
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
0
 
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
0
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.

 
Rey Obrero (Capricorn1)Commented:
upload a copy of the db
0
 
SaichandAuthor Commented:
attached is a copy.... i am still working on the combo box selection...
test.accdb
0
 
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.

0
 
Rey Obrero (Capricorn1)Commented:
test this

post back your comments

test.accdb
0
 
SaichandAuthor Commented:
i want only the jurisdiction code column to show in columns and not the other
0
 
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
0
 
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.
0
 
SaichandAuthor Commented:
are you talking about the combo box?

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

0
 
SaichandAuthor Commented:
i have a test db attached in my previous post... can you show me in it what you are saying?
0
 
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.
0
 
SaichandAuthor Commented:
i did as instructed and still need help to get the desired result. Attached is a copy of the db.
test.accdb
0
 
als315Commented:
It is impossible to have multi column form, but it is possible to emulate it.
DB26856243.zip
0
 
SaichandAuthor Commented:
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
 
SaichandAuthor Commented:
thanks a lot als315...... your suggestion on creation of multi column helps...
0
 
SaichandAuthor Commented:
I figured it out myself, but use the logic given by this individual.
0
 
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...
0
 
als315Commented:
1. It is created inside query
This is example with corrected 2 & 3
DB26856243.zip
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 11
  • 5
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now