Add a calculation field to your table and put it on your Label layout: (Use your field names in place of mine)
If ( Isempty ( shortField ) ; LongField ; ShortField )
Here is what I put in the new calculation field I just created (set as text):
If (IsEmpty (Category_Code); Category; Category_Code)
However, it shows both, even when short field (Category_Code) is not empty
There's no way the above field can "show both".
Are you removing the Category and Category_code fields from your layout and putting the above calculation field on your layout in place of them?
Oh I had address the field in the wrong table. the original was coming from a related table, however, in the if IsEmpty I had addressed the currentl table. THANKS!