Highlight in color fields in a record

[Guest]

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.

 

[Arvin Meyer [MVP]]

Conditional formatting is supported starting with Access 2000.

In a form's Design View choose Format then Conditional Formatting.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

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

 

[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

 

[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!)