[AccessD] Backcolor Problem

[Rocky Smolin]

Some serious progress, here, Stuart.

I inserted Me.DatasheetBackColor = &HA4D5E2 (the color that created a light
blue on non-datasheet forms) into the OnLoad event, and it changed the
color, albeit to a kind of tan with a burnt yellow for the column
headings.  Probably an OK color scheme. So that may be the end of this
problem.

I tried a few other colors. Never gets the color on the form that the color
picker who. Possibly it's mixing in some of the green color?

Go figure.

Thanks

Rocky


On Sat, Mar 9, 2024 at 12:09 AM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> Have you looked for something like:
>
> Private Sub Form_Load()
>   Me.DatasheetBackColor = vbBlue
> End Sub
>
> On 8 Mar 2024 at 20:30, Rocky Smolin 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:21PM 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.datashe
> > > etbackcolor
> > >
> > > 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
>