Greetings to everyone, My name is Sakthivel. I am creating a database to maintain the client details for my office. I have some issues displaying the records in report.
My database has the following fields:
Client_Name, Address1, Address2, City, Pincode, Landmark, Office_Tel, Home_Tel, Mobile1, Mobile2.
Some records in the table has empty values for some fields.
Now I want to display the records. Since some records has empty values they display as blank lines. How do i suppress them. I tried setting the field property can shrink to yes but of no avail. I also tried using a label field and set the control source as follows
=Trim([Address1]) & "," & Chr(13) & Chr(10) & Trim([Address2]) & "," & Chr(13) & Chr(10) & Trim([City]) & " - " & Trim([Pincode]) & "." & Chr(13) & Chr(10) & "Landmark : Near " & Trim([Landmark]) & "." & Chr(13) & Chr(10) & IIf(IsNull([Tel_Home]),"Phone : ","Phone : " & [Tel_Home]) & Chr(13) & Chr(10) & IIf(IsNull([Mobile1]),"","Mobile : " & [Mobile1]) & Chr(13) & Chr(10) & IIf(IsNull([Mobile2]),"Mobile : ","Mobile : " & [Mobile2])
Can some one please help me in this regard.
With Kind Regards,
Sakthivel