I have certain labels on a report that I need to hide to when a report is generated if the textbox in a form is blank. I tried to use the Can Shrink property but does not seem to allows work. So I tried the IsNull() and found that it worked only on certain ones. So I tried including the Or comparison and used forms!frmName.txtbox="" and it solved the problem. Question is whether there is an IsBlank function in access or some other function that would recognize that the field is blank but not null (as in someone erased the data or there is a space in the field but no characters. Hope you can make sense of this. Thanks much in advance.