back color

[Todd]

How can I change the back color in a field within a form
that is datasheet view?

I've got a form and subform and in the subform I've got a
notes field. What code can I put in the notes field to
where when text is entered in the notes field the back
color of the notes field turns Red, basically signifying
that there are notes included with this record? The notes
field doesn't have enough room in the subform to visibly
display all the notes so the field is only the size of the
field name. I've got the field where when you click in
the notes field a zoom box opens up to show all the notes.

Any suggestions?

 

[Fredg]

Do you have Access 2000 or 2002?
If so click on the control.
Then Format + Conditional Formatting.

Select expression, from the drop-down box.
Then enter the expression in the text box.
Probably something like:
Len([MemoFieldName]) > 0

Note: do not use an = sign.

Select the color, etc.
Save the formatting.