[AccessD] Backcolor Problem

[Rocky Smolin]

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:35 AM 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
>