Text Color in Datasheet View

[adamr99]

Is there any way to change the color of an indidual cell's text in the Datasheet view of a form?

For example, one of my fields must be above 48.0. So, if the text entered was 50 - I want it to be green. If the text was 30, I want it to be read.

Thanks in advance!
Adam

 

[Eupher]

If using Access 2000 or higher, take a look at Conditional Formatting.

Ken S.

 

[lupins46]

You can use Conditional Formatting (Format menu)in a form datasheet.

 

[adamr99]

That is what I was looking for!

Thank you!

Adam

 

[adamr99]

New question.

Is there any reason why when I open a form in DataSheet view, the data is 'calculating' until I highlight an entire row? My CPU climbs to 100% and I can't see the values in the cells.

I think that this has something do to with the conditioanl formatting.

 

[adamr99]

Found the issue:

http://allenbrowne.com/bug-05.html

Does anyone know of any 'better' work arounds than the one given on the page? (Just don't use them).

Thanks
Adam