Form border color

[Hank]

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

[Lyle Fairfield]

Hank wrote:

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 SystemColorCons tants and click the binocs. They
will be revealed unto you. For instance -2147483633 is vbButtonFace (on
my computer).
--
Lyle Fairfield

[Hank]

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

[Lyle Fairfield]

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!

[Hank]

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

[Lyle Fairfield]

I'm all for challenges. If you get stuck, holler. I have some stuff
that will do that (for Access>=2000).

[Hank]

Lyle Fairfield wrote:

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

[Lyle Fairfield]

Great!