Solved

continuous view not formatting right

Posted on 2014-02-12
11
305 Views
Last Modified: 2014-02-19
In my database when I change a couple subforms to continuous view it makes the format all jumbled.  How do I take it out of datasheet view and move to continuous view without it getting all jumbled.  I just need one header for each column of info and have a list below that.

See attached.  I am changing the notes subform and the actions and opps subform
1st.accdb
0
Comment
Question by:lehi52
  • 7
  • 4
11 Comments
 
LVL 61

Expert Comment

by:mbizup
ID: 39854857
What exactly should we be looking at in your database?

In general, if you want a continuous form to look like a datasheet, you need to align the controls horizontally in a row, reduce the height of the detail section so that it is the same height as the row of controls, and place the labels in the Form Header section, above their respective controls.

Try this, and post back with any specific problems you have with that (here to help, but not to do the work for you).
0
 

Author Comment

by:lehi52
ID: 39854859
I tried that earlier but there was a header for each person.
0
 
LVL 61

Expert Comment

by:mbizup
ID: 39854878
Can you post a database showing what you tried?   Or if it is in this database, explain what we need to do to see your work.
0
 

Author Comment

by:lehi52
ID: 39854892
Look at the Q_Actions and Opps Form.  It needs to look like the contact form1.  With a header called action date.  Then it lists the action dates below that for each person.
2nd.accdb
0
 
LVL 61

Expert Comment

by:mbizup
ID: 39854898
<< a header for each person.>>

It sounds like you placed the labels immediately above the controls, in the detail section of the form.

The controls should be in the detail section.

The labels should be above them in the header section of the form.  

You might need to cut (delete) and paste the labels from the detail section to the header section.

You will also have to drag the bar labeled "Detail" downwards to increase the size of the header section to accommodate the labels.
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 61

Expert Comment

by:mbizup
ID: 39854899
Checking out the db now... missed your last post.
0
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 39854911
Okay... compare those two forms in design view.  They are very different.

Contact form 1 has as  in my earlier comment:

1.  All of the controls lined up horizontally
2.  All of the labels above the controls, but in the form's *header* section

You need to rearrange the controls in Q_Actions and Opps Form so that the layout looks like the layout in your Contact form.

You'll have to cut/paste the labels into the header section, resize the header section arrange all controls in a horizontal line, and resize the detail section.
0
 

Author Closing Comment

by:lehi52
ID: 39854928
Thank you.
0
 

Author Comment

by:lehi52
ID: 39854993
Quick follow up.  Look in the contact form.  in the sections where you can add the action date person to contact,  action description,  etc.   Its just a white box with no lines.  Is there a way to add something so that it defaults to two lines.  Or a line below the first line.
3rd.accdb
0
 
LVL 61

Expert Comment

by:mbizup
ID: 39855014
Will check in an hour or so when I get home.
0
 
LVL 61

Expert Comment

by:mbizup
ID: 39855104
Try this  (general formatting suggestions for continuous forms):

1.  Set the form's Record Selectors property to YES
2.  For each of the textboxes, change the transparent borders to something visible, so that you can see the cells your data is in.
3.   Set the textboxes all to the same height.  You can do this by selecting all at once, right clicking and selecting  Size --> To Tallest.
4.   Align then perfectly vertically so that the tops and bottoms are aligned
5.   Size and/or move them so that there is no space between the textboxes.

By doing that, the text box borders will become 'lines' between the rows of your continuous form which I think will have the overall appearance you are looking for.

Another property you might want to try is the form's Dividing Lines property - which places dark lines between rows in your continuous form.  The advantage of using the textbox borders instead of dividing lines, however is that it gives you more control over the color and appearance of the lines between rows.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

920 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

14 Experts available now in Live!

Get 1:1 Help Now