Using Empty or Null values in condition macro

[Moss100]

Hello I have a condition macro that looks up a value in a combobox row (text value).

I would like the combo to do one action if the field contains a value and do another action if the field is null (or empty)

I have used the following:

[combo38].[column](9)is null

[combo38].[column](9)is not null

But this does not seem to have the desired result.

Any help gratefully received

Regards

Mark

 

[PHV]

What about this ?
Trim([combo38].[column](9) & "") = ""

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886