Form not looking right. How to fix

Posted on 2014-02-10
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 500 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.
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 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
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.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

738 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