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

On 4 Jun 2005 at 21:58, Kostas Konstantinidis wrote:

> 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?
> 

There is a difference between Null  an empty string  ("").. If you are 
getting a vertical blank line, I'd suspect that one of the fields contains 
an empty string rather than a Null.

Try replacing IsNull with NZ([Production],"") = ""  




-- 
Stuart