[AccessD] Backcolor Problem

[Rocky Smolin]

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
>