Tech or Treat! Write an article about your scariest tech disaster to win gadgets!Learn more


Form not looking right. How to fix

Posted on 2014-02-10
Medium Priority
Last Modified: 2014-02-19
Im adding a sub form to an access database form.   I added the leads list to the contact sub form. I dont like the look of the sub form.  

First,  I dont want it to have a scroll bar if there is nothing to scroll to.  But it is there.
Second.  How would change the header format.
Question by:lehi52
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
  • 5
  • 4

Author Comment

ID: 39848860
Here is a sample on how I would like it to look.  There is no horizontal scroll bar. It is just a lot cleaner. The headers are better, no footers.
LVL 21

Accepted Solution

Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 1000 total points
ID: 39848946
First,  I dont want it to have a scroll bar if there is nothing to scroll to.  But it is there.
IMHO, and from user feedback testing UI for UX, I have found no UX benefit to this so I have never tried.

Second.  How would change the header format.
My guess is you are using Datasheet view. Try switching to continuous form view. I almost always you continuous form view because I have a lot more control over how it looks and other things.

Author Comment

ID: 39850885
I dont see a continuous.  The only options I see are Columnar, tabular, datasheet, and justified.
 [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 Closing Comment

ID: 39851285
I closed it and opened a new thread with more detail and a sample database.  HOpefully I can get the final answer to that.
LVL 21
ID: 39851870
I finally got to a place to look at your posted database.

Open the form "Lead List" in design view. Look at the Form's property sheet. Change the default view property

Form Properties
LVL 21
ID: 39851897
I took a few minutes and updated your form to look a lot more like the image you posted of vTiger.

Updated screen2.accdb
LVL 21
ID: 39851958
I see from your other question you figured it out.

Author Comment

ID: 39851991
Actually your follow post did help.  I wasnt sure how to remove some of the headers and selectors and stuff like that.  I just copied your settings and put it into the database I already have.  Thank you.
LVL 21
ID: 39852284
You're welcome.  Glad I could assist.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

647 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