I have a 2 part question:
1. Is there a way I can change the size of the Detail section of a Form or Report. Currently I can only get the size to abt 22"(Default), and I need to enlarge the detail section to abt 45"
2: Is there a way in a Report to selectively print only fields that have information? Example: I have fields in a Table and Form that are YES/NO answers...these fields also have a Comment/Memo fields associated with them. What I am attempting to do is only print the YES/NO and associated MEMO fields if the MEMO field has data in it; if the MEMO field is blank and no data exist for the specific YES/NO question, then print "NO COMMENTS".
Change size of the Detail section of Forms/Report & selectively print Report fields

Thanks for your help.

hi,
you can change the size of the details section by rigth clicking the details section,and clicking on the properties ,go through the properties u will find the property that has to do with the size,alter it.
another method is by expanding the length of the detail section in the design view of the form or report,

for your second question,on the on load,or open event of the report,try the 2,1 will work.
enter the following code lets assume the field name is (status) then typpe the following code

if isempty(status) then status.visible is false.

try it.