Hide Null Values in Report

[rdr910]

I have created a report that can list up to 10 different phone numbers per business. Some of the businesses due have 10 phone numbers and some others might only have one or two. That looks really funky when printing. I would like the report not to show the TAG or TEXT BOX if the value is NULL and shift the rows below that would have a phone number UP.



I have already tried the CAN SHRINK property and set to YES. This is not working

Can someone please help!

[aytee111]

I can't remember if a list box would work, otherwise try a subreport.

[mejia.j88]

how are the phone numbers stored in the table?

[rdr910]

The numbers are broken down into different fields. I have a field for Daytime Phone, Nighttime phone, Secondary, Cell1, Cell2, Cell3, Cell4, Home Phone, Pager, Fax, Backup, Speed dial.

This is was the report looks like

[aytee111]

One text box populated in VBA with labels and values when not null.

[rdr910]

I created a subreport for this and populated the label textbox with code. The code works! I did the CanShrink and CanGrow properties. When i go to run the report, everything works, but the labels will appear one row beneath where it should. It is not appearing next to the phone number it should. This is the way it is appearing below

[aytee111]

I'm not too sure what you did to get this. Can you attach this part of your database?

[rdr910]

sorry it actually looks like this. The phone numbers will rise upwards, while the labels go downwards.

[aytee111]

You need to string them together so that they are on the same line.

[rdr910]

What do you mean by string them together?

[aytee111]

Like I say, I'm not sure how you are creating this. However, a string would be something like "Phone Number: '" & [Phonenumber] & "'" - you put different things together using the & to make up a string (a line of text).