How to highlight memo when value is null

Juhas

Hi, I tried very hard, but haven't worked it out.

In my database I have a datetime field(named firstIn). And it can be null.
When it's null I want to highlight a memo.

So, I check the memo, go into highlight editor, I chose desired color and then:

<frxDBDataset."firstIn"> = null - doesn't work, none of the records are highlighted
ValidDate(<frxDBDataset."firstIn">) = false - doesn't work. Every record is highlighted
<frxDBDataset."firstIn"> = '' - doesn't work. I get conversion error
DateTimeToStr(<frxDBDataset."firstIn">) = '' - doesn't work. None of teh records are highlighted

I tried also trim function with DateToStr.
So what should I do?

Schehl

Look at your datasource perhaps the field is numeric 0 or similar depends on datasource

gordk

see my reply to the same post in the news group