Shrink empty textboxs in reports

[joaosousadias]

Hello guys,

I need your help...
I have a table with some columns, for example like this:

ID |Name |Birthday |City |Phone |Mobile
12 |John Smith |12-01-1956 | | |xyz abc fgh
13 |Mary Jolie |15-09-1988 |Paris |+44 6758899 |
15 |Linda James | |New York |klo osa das |


Now, I want to make a report that show me only the fields with values, like this:

ID: 12
Name: John Smith
Birthday: 12-01-1956
Mobile: xyz abc fgh

ID: 13
Name: Mary Jolie
Birthday: 15-09-1988
City: Paris
Phone: +44 6758899

ID: 15
Name: Linda James
City: New York
Phone: klo osa das
​

I tried many ways and I couldn't find a solution.
Can you help me with this? It would be amazing if you help me with an example in a *.mdb file...

Thank you in advance.

Joao

 

[John Big Booty]

Have a look at the Can Shrink Property and also the related Can Grow property

 

[joaosousadias]

I know the Can Shrink property and didn't make what I want...
If you know how do this, give me an example, please...

Regards,

Joao

 

[ChrisO]

Joao.

Why not give us an example of what you have already tried?

Chris.

 

[joaosousadias]

I solve my problem... see this link if you want.

http://www.utteraccess.com/forum/Shrink-empty-textboxs-re-t1955986.html&gopid=2045156#entry2045156

Thank you for all,

Joao

 

[bday]

Joao, I am having the same issue. I looked at the link you posted but do not know how to perform the function mentioned. How did you get the results you needed?