how to arrange fields in an access report

[tar28un]

Hi there,

I am designing a report in access and I am stucked on how to arrange the fields. I have got five fields. House number, extra address, street, townname, postcode
Now what I did is insert all these fields into separate lines next to each. But if there is any field empty that rown comes as blank. What I want to do is that if a field is empty it should not show it as blank , instead it should put the next field into that line

 

[ZmrAbdulla]

Sarita,
If you have Northwind DB see the customer label report.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Seek counsel of him who makes you weep, and not of him who makes you laugh.

 

[tar28un]

the customer label report in nwind database has no empty fields and that is why it is displaying well. My problem is that my databse has a lot of records with empty fields

 

[addy]

One way of doing it, although perhaps not the most elegant, is to put put your text boxes on the form, one above the other (as you have now) but set the height of each one to something like 0.01cm and space them close together. The set the 'Can Grow' property to Yes.

 

[ZmrAbdulla]

Remove(empty) some data from the customer table fields.
Then open the report.. You can see it done clean.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Seek counsel of him who makes you weep, and not of him who makes you laugh.