[AccessD] Backcolor Problem

[Stuart McLachlan]

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
>