sorry for post after saying resolevd but have issue with this
=IIf([Text106] Like 'loose*',"Use CAS GDS IN") It should display Use CAS GDS IN when the textbox106 ( yes i know silly name, not my fault ) but all i get is blank but then for the following
=IIf([Text106] Like 'pallet*',"Use PAL GDS...