[AccessD] Trying to Eliminate white space in a report it doesn't work

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 





More information about the AccessD mailing list