Not to print a field which has no value

bpaen · October 16th, 2003, 02:36 AM

I created a report in MS Access 2000. For each data record to be displayed, it has two reporting lines. The second line is for "Comment" field only. I don't want to display, subsequently not print, the comment line if the comment field is empty. How can I do it? Any help is greatly appreciated.

SerranoG · October 16th, 2003, 07:23 AM

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

bpaen · October 28th, 2003, 07:20 PM

Thank you. The answer you provided works.

Bill.

Quote:

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