Using the .Top property on a report

[wrek]

I have a report that interacts with a form.

The report only shows data fields only IF they are populated on the form.

There is a function in the report code, that checks if the form data isn't null and accordingly sets it to visible.

I also have a position variable that works like a running counter using the Top property to ensure the visible fields are spaced out evenly.

My problem is: After a certain number of pixels (around 21400) I get an error message saying the control is too large. Is that the max value for Top? Is there a way around this?

 

[Rich]

Why do you need to do this, if your form has no data then don't allow the report to open or use the NoData event, isn't that going to be easier?

 

[wrek]

There will never be 'no data' at all. Some fields will have no data, but on the form there are maybe 50 fields -- my report only shows the fields that are populated.