Making stuff visable or hiden

[Simon]

I have an report that is a brochure request letter to send to
customer, its based on a query that shows the brochures the customer
has requested but in an 0 or -1 format

how do i code it so that if its
-1 it will dispay Skiing Brochure
0 will dispay nothing ( would have been summer brochure)
-1 will dispay Winter Brochre

any help would be great

 

[KARL DEWEY]

In the query that is source for the report use a calculated field like this ---
Skiing Brochure: IIF([YourFieldName] = -1, "Skiing Brochure", Null)
In design view of the report set the Can Grow property to Yes and drag the
size of the text box to a hairline. When there is a -1 it will display the
text and not when there is a zero.