A customer input form allows for up to 3 address lines to be added plus a post code. The address label has been created to match this parameter, however on some occasions only 2 address lines (plus a post code) are used. This results in a blank line appearing above the post code.
In short, when only 2 address lines are used, i am looking to say if [Ad3] is blank then move up [PostCode] ... whilst at the same time ensuring that the post code is not then repeated on both lines
=Trim([Ad2] & ".")
=Trim([Ad3] & ".")
=Trim([PostCode] & ".")
any assistance gratefully received