[AccessD] Backcolor Problem

[Stuart McLachlan]

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