I love filemaker. Even though Im not that good at it. I really need a filemaker consultant to help. Anyway here's my issue

 

 

I want to create a packing list, one of the fields I want if not empty then put an asterisk then 'part number field' formatted in the barcode font followed by another asterisk.

 

Why am I having such an issue with this.

 

Thanks 

If ( not IsEmpty ( Table::partNumber ) ; "*" & Table::partNumber & "*" )

If it's in a calculation field, then you can leave the (default) option of "Do not evaluate if all referenced field are empty" on, and shorten the formula to =

"*" & PartNumber & "*"

Formatting the field to display in a barcode font can be done at the layout level.

 

 

This really is too easy: if you're "having such an issue with this", you should elaborate what specific problems have you run into.

Isn't this for display only?  It would be good to drop the calculation completely if possible.  Just an idea ...

 

Create a merge field of the part number inserting * before and after part number.  Then set the merge block to hide if IsEmpty ( PartNumber ).  Or would this not work because of the barcode font?