Form Field Validation Rule Multiple conditions

[thraling]

Hello,

I have 2 fields in a form:
[Plan to fill] = can be whatever
[Source] = It has to have a value, unless [Plan to fill]="TBD", then it has to be empty.

Validation rule in [Source]:
([Source]<>"") Or ([Plan to fill]="TBD" And [Source]="")
It doesn't work. Not even with tricks like Len, Trim, etc.

If I put:
([Source]<>"") Or ([Plan to fill]="TBD")
it works, but, of course, I lose the condition (If "TBD" Then [Source]="").

If I put even:
([Source]<>"") Or ([Plan to fill]="TBD" And True)
That should be the same as above, doesn't work again anymore.

What am I missing?

 

[arnelgp]

(Trim([Source] & "")<>"" And Trim([Plann to fill] & "")<> "TBD") Or (Trim([Source] & "")="" And Trim([Plan to fill] & "")="TBD")

 

[thraling]

(Trim([Source] & "")<>"" And Trim([Plann to fill] & "")<> "TBD") Or (Trim([Source] & "")="" And Trim([Plan to fill] & "")="TBD")

Your magic worked!
Thanks!

 

[arnelgp]

you're welcome and goodluck!