Formatting datasheet view in a subform.

[scottpw via AccessMonster.com]

Hi Folks,

Is there a way to format color in a datasheet view in a subform of a form?
The datasheet view stems from a query. I am able to format the background
and foreground colors when I execute the query by itself. However, when I
execute the same query to view the datasheet in a subform, I acquire the
standard white background and black font.

Could to think of it, can a drop-down menu or drop down list of records be
formatted with a background color of choice?

Any assistance is appreciated.

Scotty

 

[Al Campagna]

Scott,
I rarely use datasheet view in a subform. You have much more control over appearance
(amongst other things) if you create a continous form subform that "looks" just like a
datasheet.
Yes, both Comboboxes and Listboxes have a Background Color property.
--
hth
Al Campagna
Candia Computer Consulting
Microsoft Access MVP - Candia, NH USA
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[scottpw via AccessMonster.com]

Thanks Al,

Appreciate your response.

Scotty

Scott,
I rarely use datasheet view in a subform. You have much more control over appearance
(amongst other things) if you create a continous form subform that "looks" just like a
datasheet.
Yes, both Comboboxes and Listboxes have a Background Color property.

Hi Folks,

[quoted text clipped - 10 lines]

Scotty

 

[Ron2006]

The continuous form CAN be made to approximate the datasheet view.

You gain the ability to color the fields, etc, but lose the ability to
change sort and resize fields and change the sequence of fields across
the form..

If there are less then 3 colors and the default black on white, you can
use conditional formating in the datasheet view (and other view also)

Ron