Upon further reflection... I think I've figured out the problem, and a fix.
The problem stems from the data stored, or not stored, in the MGR field. As noted before, if there is a MGR, then If(CALL <> MGR) works. However, if there is no MGR, in other words is a null or empty field, then If(CALL <> MGR) still evaluates true since CALL has some value and MGR is a null and the two are therefore not equal. The resulting true evaluation causes the first argument to work and print the word "via" plus the MGR field which is empty. This results in a label with only the word "via" printing out where there is no MGR routing. The fix is a slight change in the logic so that the MGR field is examined first to see if it is empty or contains a value. If MGR is empty, print a null. If MGR has some value compare the CALL & MGR fields as before and if they are not equal print the "via "+ MGR string. If the fields are equal, print a null. The resulting line of new logic is: If(MGR = "","",If(MGR <> CALL,"via "+MGR,"")) Go to Tools/Design Labels and select the label to modify. Double click on the text box showing the formula, double click on the line of code and in the resulting window edit the logic formula. Be sure to pay attention to the commas and the extra parens at the end. Click ok to accept the change, click ok again and exit the design label module. The labels should print correctly now. Probably not the most elegant bit of code, but changing the formula as above results in the labels printing correctly with the "via" suppressed when there is no MGR. Gary KC9UM --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html The reason this message is shown is because the post was in HTML or had an attachment. Attachments are not allowed. Please post in Plain-Text only.---
