If textField IsNull, move everything below it up

[slaman]

Ok, I am starting a new thread because I guess my question was too confusing. I am trying to create a printable form that fits on one page. This form is a summary of all the information in the database. Now, not all fields in the database are required, meaning they can be null. This is where the confusing part comes in. If a field in the database is NULL, I want the corresponding textbox to disappear and I want all textboxs below it to move up a certain amount so the result isnt a blank space. Is this possible? If it is, what algorithm and specific methods are required?

 

[nickjar2]

I am not sure whether this can easily be done using forms (although I have never tried it)
All I can suggest is to create a new report select the source to base the report on and choose the mailing labels wizard. When I have done this before, whenever a null field (eg an empty address field) occurs the fields below have moved up. I think it uses the Trim function. When I have tried to replicate this without using the wizard I have never been able to get rid of the null fields.

Let me know if it works.

Nick

 

[slaman]

I have looked everywhere, but I do not see mailing labels or any related wizard. I have looked extensively through reference material and don't see anything. I am using Access 2002 - perhaps they removed that feature?

Trim simply removes spaces from a string, it has nothing to with removing NullFields from a form...