I have a report that I am trying to format. It looks something like this:

Title Version ID Complete Incomplete Total
Description


The report is a listing, it is a listing of surveys, it has the App Title, Version, App ID, Total Complete, Total Incomplete, Total (Complete + Incomplete)

In most instances no one bothered to put a description of the survey in however, where there is one I want it to show. Where there is not I want the report to ignore that line and move the next record up. (I don't want the extra space). Word and WordPerfect have a feature for doing this sort of thing in a merge (if Address line 2 does't exist don't leave a blank space, put the city).

I tried this using a table with two rows, it didn't wrap up automatically and I can't find a setting.

I also tried using a list object with text fields, it didn't wrap up by default and I can't see a setting anywhere.

I am sure this can be done. I just can't see it. (I think I also read someone else's post somewhere with the same issue... think I can find it again? NOT!).

******************

I am re-posting. I figured it out!

I used the version of the report with a table. I clicked on the form, selected properties, code(the tab) and added this code:

Public Function fnShowHideDescription(Value as string) as boolean
    if (trim(value) = "") then
        return True
     else
        return False
    end if
End Function

I clicked to row (designator?? button to the left of the row in the designer.) Selected Visibility. Then selected the entry called Hidden. I added this code instead of true or false:

=Code.fnShowHideDescription(Fields!AppDescription. Value)


The report now shows or hides the row as needed.

__________________
Sandy Murdock MCP