Is Null then set visible=false (1 Viewer)

[Adrianna]

Okay....I have a bunch of calculations running in my query and I'd like to know if it is possible to drop fields from my report of no information (NULL) is found in the query.

Basically, when I run this report, I want to see the totals for the groupings....and only the fields in which informaiton has been provided. This will make the form much more useful. A bunch of blank fields can be confusing and hard to read through.

Thanks

 

[Memnoch1207]

You will want to do something like this.
if IS NULL(txtdate.text) then
txtdate.visible= false
else
txtdate.visible= true
end if

OR
if Len(txtdate.text) < 1 then
txtdate.visible = false
else
txtdate.visible = true
end if

this last one checks if the length in the string is less than 1 character...if it is then its visible property is set to false.

[This message has been edited by Memnoch1207 (edited 05-10-2002).]