Constructing an address out of separate fields with conditional elements

[Dudley]

I am trying to make an address field out of fields for each part. I have got

[Forms]!SecretarialForm.PSC1Address = [Forms]!PSCSubForm.Address1 & ", " & [Forms]!PSCSubForm.Address2

If Address2 is not blank, I then need to add another ", " before adding Address3, but VBA does not seem to allow an "if then" statement at this point. Can anyone advise? Thanks. Dudley

[ranman256]

=[Forms]!PSCSubForm.Address1 & ", " & iif(Not Isnull([Forms]!PSCSubForm.Address2), [Forms]!PSCSubForm.Address2 & ",",""))

[Dudley]

Many thanks. Dudley

[pbaldy]

Or

[Forms]!SecretarialForm.PSC1Address = [Forms]!PSCSubForm.Address1 & ", " & ([Forms]!PSCSubForm.Address2 + ", ")

[Dudley]

Many thanks again. Dudley