?
Solved

continuous view not formatting right

Posted on 2014-02-12
11
Medium Priority
?
315 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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
 
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 2000 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses

864 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