p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   Not to print a field which has no value (http://p2p.wrox.com/showthread.php?t=5035)

bpaen October 16th, 2003 02:36 AM

Not to print a field which has no value
 
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


All times are GMT -4. The time now is 10:14 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.