Highlight in color fields in a record

M

Mary

I am using Access 2000. In each record, I cannot highlight in color fields
for that particular record (as you can in Excel). (I want to highlight in
color different fields in each record.) Do subsequent versions of Access
support this? If not, is there another database program that will do it.
 
M

Mary

Dear Arvin:

Perhaps I was not clear. In Datasheet view, I want to look at the table
data I have entered and highlight different entries in color. I don't want
conditional formatting. Thanks.

MARY
 
A

Arvin Meyer [MVP]

There is no special cell formatting in datasheet view. You can do
conditional formatting in a continuous view and make it look like a
datasheet by butting the controls up to each other and using borders. If you
want to just color the cell under "all" conditions, the condition can be
something like using Expression Is and:

Len([FieldName])>0
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
D

Douglas J. Steele

If I'm understanding you correctly, that's not possible in any version of
Access. The closest you can come is Conditional Formatting.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)
 
Top