Textbox Backcolor

[Joe Delphi]

Hi,

I have a textbox on a form and I set the BackColor property to gray.
The form is set to display in DataSheet mode, when it displays, the
backcolor appears as the default white, which is not what I want. There
are other textboxes on the form, that I want to stay at the default setting
of white.

Can someone tell me how to set the Backcolor property so that it
stays set when the form is displayed in datasheet mode?


Thanks,
JD

 

[fredg]

Hi,

I have a textbox on a form and I set the BackColor property to gray.
The form is set to display in DataSheet mode, when it displays, the
backcolor appears as the default white, which is not what I want. There
are other textboxes on the form, that I want to stay at the default setting
of white.

Can someone tell me how to set the Backcolor property so that it
stays set when the form is displayed in datasheet mode?

Thanks,
JD

You can't.
When viewing a form in Datasheet view, the backcolor and forecolor (as
viewed in Single Form or Continuous Form view) are ignored.
Instead, the backcolors (as well as forecolors) are whatever is chosen
by the user (while in Datasheet view), by selecting Format + Fonts or
Format + Datasheet.
Every record and field in the datasheet has the same forecolor and
backcolor, (unless you are using conditional formatting).

 

[Donald A. Herman]

As far as I know , you can only change them all (columns). Choose Format
menu than Datasheet.

--
Donald A. Herman
Software - Scheduler Pro, Disk Cataloger, Math Wizard
http://don_herman.tripod.com
Office Extras, Addins
http://don_herman.tripod.com/msoextras
..
..

 

[Dirk Goldgar]

Hi,

I have a textbox on a form and I set the BackColor property
to gray. The form is set to display in DataSheet mode, when it
displays, the backcolor appears as the default white, which is not
what I want. There are other textboxes on the form, that I want to
stay at the default setting of white.

Can someone tell me how to set the Backcolor property so that
it stays set when the form is displayed in datasheet mode?

Although you can't do it in datasheet view, you could design a
continuous forms view that would look a lot like a datasheet. You'd be
hard put to incorporate the special datasheet functionality, though,
like hiding and freezing columns.

 

[Larry Daugherty]

I wouldn't accept that achieving any effect on forms and on reports
couldn't be done unless Stephen Lebans joined the thread and said that
it couldn't. Check out his offerings at www.lebans.com You may get a
happy surprise.

My ignorance is vast and my experience is limited: I don't believe
that I've ever deployed an application with a Datasheet View enabled.
My choice has always been to use the continuous forms paradigm
detailed by Dirk. I use that a lot. It leaves control over most
aspects of the design in my hands.

Often the end effect we seek is available if we'll simply detach
ourselves from achieving it via a particular method.

HTH

 

[Stephen Lebans]

The OP can use Conditional Formatting to achieve the desired effect.
http://www.lebans.com/conditionalformatting.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.