Testing for a blank string control value using vb

[Isis]

I want to carry out some field edits based on the value of another string
field - I can not seem to test it for having no value using;

If [Field] = "" - does not fire if field is blank

If [Field].Text = "" - does not fire if field is blank

Obviously not doing the right thing - any help appreciated.

Is it possible to compare the contents of String and Numeric fields ?


Thanks

 

[Ed Robichaud]

IIf(IsNull([myField]) doA, doB)

-Ed