Sub Form Text Color

[Scientific]

Hello all,

Is there a way to have text in a different color other than black in a sub
form. I have two text boxes on a sub form. I changed the text color for the
text boxes to blue but when the sub form loads the text defaults to black.
Any ideas on this are welcome.

-S

 

[tina]

if the subform's DefaultView is Datasheet, then no, you can't affect a
single field, only the datasheet as a whole. you might check Stephen Lebans'
website; if anybody has come up with a way to do it, i'd bet it would be
him. http://www.lebans.com/

hth

 

[MikeJohnB]

There is a way for a datasheet form but its messy and I don't like it but.

With the subform in design view, select the Control you want to change the
font colour for,

On the format menu, Select Conditional Formatting

In condition 1

Select Feild Value is
Next box along Select Greater than
Next Box Along Type ""
(Two sets of Quotes)
Set the font colour to the Blue you want.

Repeat for the second control.

The draw back:

As the subform loads, the font colours are as default, BLACK, on loading,
the conditional format changes the font colour to Blue.
So it appears slowly to change the font.

But hey, I said it was messy.

Hope this helps

Regards

Mike B

 

[Mike Painter]

You can make a continuos form look like the datasheet view and work with
that.
It takes a bit more fooling with fields etc. but works well.

 

[Scientific]

All Responders,

Thanks for the valuable info. At least I have some options I didn't think
were possible. Many thanks to all of you for providing avenues by which to
approach this. I am deeply grateful for your thoughts on this.

-S