Formatting datasheet view in a subform.

  • Thread starter Thread starter scottpw via AccessMonster.com
  • Start date Start date
S

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
 
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."
 
Thanks Al,

Appreciate your response.

Scotty
Al said:
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,
Click to expand...
[quoted text clipped - 10 lines]
Scotty
Click to expand...
Click to expand...
 
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
 
Back
Top