Solved

continuous view not formatting right

Posted on 2014-02-12
11
309 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
Technology Partners: 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 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

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.

Question has a verified solution.

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

Suggested Solutions

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
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…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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.

685 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