[AccessD] Backcolor Problem

Sat Mar 9 11:03:20 CST 2024

Well, here's an interesting twist - I deleted the backcolor property, which
I had set to blue in a futile effort to get the backcolor of the datasheet
to change. Access defaulted it to #000000. Went to form and and...it's
still green.

How the heck did the old programmer do that?

r

On Fri, Mar 8, 2024 at 11:24 PM Paul Hartland via AccessD <
accessd at databaseadvisors.com> wrote:

> I assume you have checked that you are using the standard colour blue and
> not the theme colours, as I think the theme colours can vary sometimes
>
> Paul
>
> On Sat, 9 Mar 2024, 04:31 Rocky Smolin, <rockysmolin2 at gmail.com> wrote:
>
> > Which still leaves the question unanswered - if the backcolor of the
> detail
> > section is blue, and the backcolor of all the fields is blue, why, when
> the
> > formis opened in datasheet view, is the backcolor green?  What's
> > changing it?
> >
> > r
> >
> > On Fri, Mar 8, 2024 at 6:21 PM Stuart McLachlan <stuart at lexacorp.com.pg>
> > wrote:
> >
> > > Yep, I was missing something.
> > >
> > > It's not a standard DAO property  avaiable in Design mode.
> > >
> > >
> > >
> >
> https://learn.microsoft.com/en-us/office/vba/api/access.form.datasheetbackcolor
> > >
> > > In A21, when in DataSheet view, you can set it with the Menu Item Form
> > > Datasheet -
> > > Background color.
> > >
> > > Since I rarely use datasheets, I've never noticed that before.
> > >
> > >
> > > On 9 Mar 2024 at 12:10, Stuart McLachlan wrote:
> > >
> > > > I must be missing someething.
> > > > I've never seen a datasheet that was other than black, grey and
> white?
> > > > And I've never seen a way to change that.
> > > >
> > > > Are you talking about the actual cells and headers  or is the
> > > > datasheet embedded in another form?   (It sounds like the latter and
> > > > you are not editing the parent form.
> > > >
> > > >
> > > > On 8 Mar 2024 at 15:24, Rocky Smolin wrote:
> > > >
> > > > > Paul:
> > > > >
> > > > > That sounds like what I'm looking for but I can't find
> > > > > the DataSheetBackColor property on the property sheet or in
> > > > > File-->>Options.  I'm using Access 2010 for this client because
> they
> > > > > are still running it on a couple of stations. It is a legacy system
> > > > > originally built in perhaps A2003?
> > > > >
> > > > > In design view I can change the backcolor of the datasheet to blue
> > > > > but when I go to form view it returns to the original green color.
> > > > > So there must be something in this db that's setting that
> backcolor.
> > > > > Danged if I can find it though. I searched the code - no reference
> > > > > to datasheet. I went to the web but none of the instructions
> matched
> > > > > up with the Access I'm using.
> > > > >
> > > > > Where do you find that DataSheetBackColor property?
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Rocky
> > > > >
> > > > >
> > > > > On Fri, Mar 8, 2024 at 9:35AM Paul Hartland via AccessD <
> > > > > accessd at databaseadvisors.com> wrote:
> > > > >
> > > > > > This one threw me a little, I may be reading it wrong, the last
> > > > > > bit says you want to change the backcolor of a continuous form
> but
> > > > > > the piece above it says you changed it from a datasheet to a
> > > > > > continuous and it worked and you don't want to change everything
> > > > > > to continuous.
> > > > > >  So I am assuming that you have datasheets and you want the
> > > > > > backcolor changed, does it not work when changing the property
> > > > > > DataSheetBackColor.
> > > > > >
> > > > > > Paul
> > > > > >
> > > > > > On Fri, 8 Mar 2024 at 17:20, Rocky Smolin <
> rockysmolin2 at gmail.com>
> > > > > > wrote:
> > > > > >
> > > > > > > Dear List:
> > > > > > >
> > > > > > > I am working with a legacy db that I have done a lot of work on
> > > > > > > over the years. My contact there called yesterday and said they
> > > > > > > wanted to set up a second database and change the backcolor of
> > > > > > > the forms from green to blue. So they'd have an unmistakable
> > > > > > > clue as to which database they were in.
> > > > > > >
> > > > > > > I ran into a problem when tried to modify the backcolor of the
> > > > > > > first
> > > > > > form.
> > > > > > > I changed the backcolor of the header and detail sections to
> > > > > > > blue, and changed the backcolor of the fields to blue. But when
> > > > > > > I opened it up the color was still green.
> > > > > > >
> > > > > > > After looking every place I could think of where the color
> might
> > > > > > > be changing (code, conditional formatting, etc.) I tried
> > > > > > > changing the format from datasheet to continuous form and got
> > > > > > > the blue color I
> > > > > > wanted/expected.
> > > > > > > But there are a lot of forms and I don't want to reformat them
> > > > > > > to continuous if I can avoid it..
> > > > > > >
> > > > > > > There's some secret about how to set the backcolor of a
> > > > > > > continuous form that I'm missing.
> > > > > > >
> > > > > > > Does anyone know?
> > > > > > >
> > > > > > > MTIA
> > > > > > >
> > > > > > > Rocky
> > > > > > > --
> > > > > > > AccessD mailing list
> > > > > > > AccessD at databaseadvisors.com
> > > > > > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > > > > > Website: http://www.databaseadvisors.com
> > > > > > >
> > > > > >
> > > > > >
> > > > > > --
> > > > > > Paul Hartland
> > > > > > paul.hartland at googlemail.com
> > > > > > --
> > > > > > AccessD mailing list
> > > > > > AccessD at databaseadvisors.com
> > > > > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > > > > Website: http://www.databaseadvisors.com
> > > > > >
> > > > > --
> > > > > AccessD mailing list
> > > > > AccessD at databaseadvisors.com
> > > > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > > > Website: http://www.databaseadvisors.com
> > > >
> > > >
> > > > --
> > > > AccessD mailing list
> > > > AccessD at databaseadvisors.com
> > > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > > Website: http://www.databaseadvisors.com
> > > >
> > >
> > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>