How skip blank fields in Access Report?

[Guest]

I have a database with 18 fields. I have data for the first three fields in
all records but only some records have any data in some of the remaining 15
fields (and always different fields). How do I prepare a report that will
only print the fields that have data? In other words, how do I get my Access
Report to just skip all the blank fields in a particular record? I tried
"can shrink" but it still gave me blanks.

Thanks!

 

[Duane Hookom]

Blank fields are never displayed in a report unless you display their
border. The controls will always shrink if you have their Can Shrink
property to Yes and their value is Null/empty.

If you want to close up empty spaces in reports, you can only do this where
no other (non-shrinking) control is located to the left or right of the
control you want to shrink.

 

[Chuck]

I have a database with 18 fields. I have data for the first three fields in
all records but only some records have any data in some of the remaining 15
fields (and always different fields). How do I prepare a report that will
only print the fields that have data? In other words, how do I get my Access
Report to just skip all the blank fields in a particular record? I tried
"can shrink" but it still gave me blanks.

Thanks!

My experience with can shrink is Access97 has not been good.

Put everything that will be in a single line in a single text box.
Example: =[City] & ", " & [State] & " " & [Zip]

Suggest you set the property for the first three lines to can shrink = no, can
grow = no. Then for the next twelve lines set each line height to 0.0007,
each line top to be 0.0007 below the bottom of the previous line, and each can
grow = yes. There will in fact be a blank space equal to 0.0014 inches high
where a line is blank. This is not noticable in a print out.

Just a wizard prodder.
Chuck
....