• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 319
  • Last Modified:

continuous view not formatting right

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
lehi52
Asked:
lehi52
  • 7
  • 4
1 Solution
 
mbizupCommented:
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
 
lehi52Author Commented:
I tried that earlier but there was a header for each person.
0
 
mbizupCommented:
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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
lehi52Author Commented:
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
 
mbizupCommented:
<< 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
 
mbizupCommented:
Checking out the db now... missed your last post.
0
 
mbizupCommented:
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
 
lehi52Author Commented:
Thank you.
0
 
lehi52Author Commented:
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
 
mbizupCommented:
Will check in an hour or so when I get home.
0
 
mbizupCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 7
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now