show only fields where data is inside access 2002

[pigone]

Hello,

is it possible to generate a report where only these fields are shown,
in wich data can be found? I have a large table and everyone has
somthing in another colum. so if i make a report i have all the
coloums in there but only need some of them.

please excuse my english ( if this is english at all)

Peter

 

[Allen Browne]

If you set the Can Shrink property of a text box in your report, it will
take up no vertical height in the report when the field is Null.

It only works if there is nothing else beside it (overlapping it
vertically.) Typically you have a label beside it, and so the label prevents
it from shrinking. to get around this, right-click the label and Change To |
Text box. Then enter an expression so this quazi-label text box is Null when
the other text box is null.

For example, you might have a label and text box on a line of its own in the
report, looking like this:
City: New York
You change the "City:" label into a text box, and give it these properties:
Control Source =IIf([City] Is Null, Null, "City:")
Can Shrink Yes
Top exactly-the-same-number-as-the-City-text-box.