I am using the following as the default value for a field in a form. if the owner address is not null it shows the information in the field , but if the owner address is null the following customer information listed name,address,city,state,zip does not show. should this be IFF statement and not the NZ statement...
=Nz([Forms]![Customer]![Owner Address],[Forms]![customer]![firstname] & " " & [Forms]![customer]![lastname] & Chr(13) & Chr(10) & [Forms]![customer]![street number] & " " & [Forms]![customer]![address] & Chr(13) & Chr(10) & [Forms]![customer]![City] & " " & [Forms]![customer]![state] & " " & [Forms]![customer]![zip])
this is what is in the control source for the owner address...
=[CompID].COLUMN(1) & Chr(13) & Chr(10) & [CompID].COLUMN(2) & Chr(13) & Chr(10) & [CompID].COLUMN(3) & " " & [CompID].COLUMN(4) & " " & [CompID].column(5)
Did know if you would need the above added just in case Thanks Angie