[AccessD] Backcolor Problem

[Rocky Smolin]

The datasheet is embedded in another form - a subform to the main form. And
I have no earthly idea how the original programmer got it to be green.

r

On Fri, Mar 8, 2024 at 6:11 PM Stuart McLachlan <stuart at lexacorp.com.pg>
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
>