Brian,
You can't do this in the Report Open event. The control's have no data yet.
Anyway you were given code to do this using the report's Detail Format event
(assuming the memo field was in the detail section).
If you have Access 2000 or 2002, you can use the control's conditional
formatting.
Select the [memo field]. Click on Format + Conditional Formatting.
Set the Condition 1 drop-down to
Expression Is
in the Text box along side the drop-down, write:
[MemoField] Is Not Null
Select the colors for when the condition is met and when it is not met.
--
Fred
Please reply only to this newsgroup.
I do not reply to personal e-mail.
"Brian" <br************@ci.verona.wi.us> wrote in message
news:21**************************@posting.google.c om...
I'm pulling what's left of my hair out. I'm trying to check a memo
field on opening a report. If the field has "value", I'd like to
change the fields back color. If it's "Empty", I'd like to leave it
white. (i.e. if their is data in the memo field, I want it
highlighted in yellow.) I've tried isnull, isempty, ="", all with no
luck. I'd appreciate any suggestions and thanks in advance.
Brian