Afternoon all,

I am using Access 2007 and I am trying to get rid of extra spaces when there is no data to display on my report. I created a database that is used as a phone directory. I set the report to display two columns: one for the local information and the other for the corporate info. I have created unbound text boxes to display the info and an IF/ELSE statement if fields are blank. Since it is in two columns, when I expend the unbound text box on the corporate side to display all the info it also expends on the local side and gives me blank spaces. I have set the 'can shrink' and 'can grow' properties to 'Yes' on the property sheet but that didn't do anything.

All the information entered under the corporate section on the right is what is giving me the extra spacing on the left side. So I need to find a way to get rid of the spaces that are under 'Samantha Smith' and shift every thing up.

I have tried to set the height of the 'Details' section to 1, but it won't let me do it as the unbound text box for the corporate information is large. And if I make that smaller then I loose data. as some of the fields will be cut off.

I can email screen shots if needed. I have 4 files of aproximately 200.00 KB each and they are too big for attaching.

Thanks for the help.