Solved

Horizontal line doesn't extend to width of form

Posted on 2013-05-20
4
492 Views
Last Modified: 2013-05-20
I have a form with a horizontal line between the header and the detail sections.  I'm using tabbed document for the current database.  How do I make the line fill the horizontal width of the form?
0
Comment
Question by:SteveL13
[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
4 Comments
 
LVL 12

Expert Comment

by:pdebaets
ID: 39181315
If you see a bit of space on the right, it may be because you have the vertical scroll bar enabled, even though the bar itself doesn't appear. Try setting your form ScrollBars property to Horizontal Only, or None.
0
 
LVL 48

Assisted Solution

by:Dale Fye (Access MVP)
Dale Fye (Access MVP) earned 250 total points
ID: 39181431
Is this only occuring on your computer, or on others?

When you draw the line, it must be wide enough to extend across your entire screen.  If you have the navigation pane open during form design, the "form" width is less than it might be if you have the navigation pane closed.  If that is the case, just change the width of the line.

This could also be an issue of designing the form on one screen and actually displaying it in a different screen size of resolution.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 250 total points
ID: 39181606
Is this a deal breaker.?
I would just live with it...
...because the ultimate fix might also create some unwanted side eeffects
(I personally hate tabbed windows because I only keep one form open at a time...)


Solution 1
The brute force, work everywhere answer.

Make the line 22 inches long
(This will make the form 22 inches wide as well)
22 is the max width of a form.

By doing this, no matter how big the screen, or what the users resolution is, the line will always extend to the end of the form.

*Issues* with doing this:
1. This assumes that Tabbed documents will *always* be the database style, else all of your forms will be 22 inches wide)
2. This forces a horizontal scroll bar to always appear, even if there are no controls to scroll to ( Yes, you can turn off the scroll bar, ...but this means users can't scroll even if there are controls to the right of the visible area)

Again, for me this is a non-issue.
The line not extending is the least of my worries,
;-)
...as I can't see how this will effect the user in any way...


Solution 2. (much better IMHO)
Don't use a "Line", ...just change the color of the header.
By changing the color of the form header it will always appear across the entire form.
Like so:
form header
JeffCoachman
0
 

Author Comment

by:SteveL13
ID: 39181635
To be honest I really don't like tabbed forms either but it seems one of our people wants this one to be that way.  I think I'll either get rid of the lines or make 'em long enough to satisfy most screen resolutions.

Thanks.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

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.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

691 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