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

Form not looking right. How to fix

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.
1.accdb
0
lehi52
Asked:
lehi52
  • 5
  • 4
1 Solution
 
lehi52Author Commented:
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.
page-sample.png
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
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.
0
 
lehi52Author Commented:
I dont see a continuous.  The only options I see are Columnar, tabular, datasheet, and justified.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
lehi52Author Commented:
I closed it and opened a new thread with more detail and a sample database.  HOpefully I can get the final answer to that.
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
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
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
I took a few minutes and updated your form to look a lot more like the image you posted of vTiger.

Updated screen2.accdb
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
I see from your other question you figured it out.
0
 
lehi52Author Commented:
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.
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
You're welcome.  Glad I could assist.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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