View Single Post
  #3 (permalink)  
Old October 28th, 2003, 07:20 PM
bpaen bpaen is offline
Registered User
Join Date: Oct 2003
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts

Thank you. The answer you provided works.


quote:Originally posted by SerranoG
 Have you tried setting the comment field's CAN GROW and CAN SHRINK properties to YES? This will allow the field to become as big as it needs be (can grow) and also shrink down to nothing if it's empty (can shrink).

You can also put something on the report's On Format event in the detail section that says if the comment field is null then its VISIBLE property = FALSE, else it's TRUE.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Reply With Quote