[AccessD] Backcolor Problem

[Stuart McLachlan]

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