 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / December 2005Form border color
To this point I have used a color for my form background (detail, header, or footer) that is approximately the same as the hard-wired background color of command buttons. For the record, the color value I use is -214748363. Then I choose a different color (anything - pick white for instance) for the form background. When I switch to form view, there is about a 3/8-inch wide border on the right and bottom of the form, which is very close to the color, mentioned above (-2147483633) By the way, this color is NOT available from the palette of 40 colors available in design view. I'm using Access 2000. It is a little bit distracting and doesn't go well with some form background colors. It is especially noticable when placing a sub-form on a form. Do I have access to the color setting of this border so I can match it to the rest of the form? Thanks, Hank Reed > Do I have access to the color setting of this > border so I can match it to the rest of the form? You could open a standard module. Then click on the object browser icon. It's a little yellow box with red green and blue thingmes above it. In the search combo type SystemColorConstants and click the binocs. They will be revealed unto you. For instance -2147483633 is vbButtonFace (on my computer).  SignatureLyle Fairfield Lyle, Thanks, you're always on top of everything. In my post, I should have said that I want to change that border color programatically. I had posted last week about using VBA to change the background color of all forms, based on what a user picked off the color dialog. I solved that problem, but any forms with a color other than vbButtonFace had this disconcerting border bar on the bottom and right side. We do have a good reason for dynamic color changes for forms. ;-) Hank Reed Hank I'm not sure I completely understand your situation. TTBOMK the colors of things like scroll bars and record selectors of an Access form cannot be changed independently of changing sustem colors, which can be done with API calls. Because such change impacts everything on the computer, many of us don't want to go there. But my forms don't have that 3/8" unwanted borders that you describe. Why not and what are these borders? Without seeing them I'd guess they're space for Scrollbars, which you have set to "Always" somewhere in your form properties and, perhaps, if you can change the settings they will disappear. But that's a guess! Lyle, You're right again. That was good deductive reasoning based on the fact that they only appeared on the right and bottom. It appears to be a space reserved for a scroll bar if one is needed. By changing the scroll bar setting to "Neither", the border bands disappear. Just never saw them before when everything was the same color. Now the only place I have the border bands is on a few sub-forms that are continuous forms. And even then, I can eliminate the horizontal bar. Now, if I was real smart, I would only enable the vertical bar if a certain number of records are present on the continuous form. There's a mini-chalenge. Thanks again, Hank I'm all for challenges. If you get stuck, holler. I have some stuff that will do that (for Access>=2000). > I'm all for challenges. If you get stuck, holler. I have some stuff > that will do that (for Access>=2000). Actually it was quite simple and all my forms now look better and have a little more space. It was easy to look at the size of the recordset and hide or show the vertical scroll bar as needed as I step from record to record. Used the sub-form On_Current event. Thanks for sticking with this. Hank Great! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.