Kostas Konstantinidis
kost36 at otenet.gr
Sat Jun 4 13:58:40 CDT 2005
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