Mike & Doris Manning
mikedorism at verizon.net
Sat Jun 4 19:25:55 CDT 2005
You are correct that you do need to set the Details section to CanShrink = Yes. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kostas Konstantinidis Sent: Saturday, June 04, 2005 2:59 PM To: Access Developers discussion and problem solving Subject: [AccessD] Trying to Eliminate white space in a report it doesn't work Hi all, in a report I use the follown =IIf(IsNull([Production]);"";[Production] & Chr(13) & Chr(10)) & IIf(IsNull([PROD_ADDRESS]);"";[PROD_ADDRESS] & Chr(13) & Chr(10)) & IIf(IsNull([Address2]);"";[Address2] & Chr(13) & Chr(10)) & IIf(IsNull([Communication]);"";[Communication]) & Chr(13) & Chr(10) & IIf(IsNull([PROD_E_MAIL]);"";[PROD_E_MAIL]) & Chr(13) & Chr(10) but in case one of the in between Production and Addess2 records are blank and PROD_E_MAIL is not, then it seems it doesn't eliminate the vertical space holding white space am I doing something wrong or it needs to CanShrink the Details too? I also tried the Microsoft's Public Function on http://support.microsoft.com/default.aspx?scid=kb;en-us;299011 but the result remains the same Thank's Kostas Konstantinidis -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com