[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

continuous view not formatting right

Posted on 2014-02-12
11
Medium Priority
?
314 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 

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

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!

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

650 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