Solved

Form not looking right. How to fix

Posted on 2014-02-10
9
323 Views
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.
1.accdb
0
Comment
Question by:lehi52
  • 5
  • 4
9 Comments
 

Author Comment

by:lehi52
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.
page-sample.png
0
 
LVL 21

Accepted Solution

by:
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.
0
 

Author Comment

by:lehi52
ID: 39850885
I dont see a continuous.  The only options I see are Columnar, tabular, datasheet, and justified.
0
 

Author Closing Comment

by:lehi52
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.
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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
0
 
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
0
 
LVL 21
ID: 39851958
I see from your other question you figured it out.
0
 

Author Comment

by:lehi52
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.
0
 
LVL 21
ID: 39852284
You're welcome.  Glad I could assist.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

867 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now