missing text while concatenating?

[rienk]

Hi all,
I've got this unbound textfield where I concatenate the following:

=IIf([vector_map]<>&quot;&quot; Or [sequence_info]<>&quot;&quot;,&quot;&quot;+Chr(13)+Chr(10) & &quot;Related files:&quot;,&quot;&quot & IIf([vector_map]<>&quot;&quot;,&quot;&quot;+Chr(13)+Chr(10) & &quot;Vector map: &quot; & [vector_map],&quot;&quot & IIf([sequence_info]<>&quot;&quot;,&quot;&quot;+Chr(13)+Chr(10) & &quot;Sequence info: &quot; & [sequence_info],&quot;&quot

Ok, the problem is that it shows only one of the two vars at a time with vector_map in favor... what is wrong? I checked it a bah-zillion times now, but I guess I need another pair of eyes, too.
Or could it be that there's a limit in the no. of concatenated text-strings? I've already got two others with a lot of IIf functions and all...

 

[jdegeorge]

Rienk

Why are you putting &quot;&quot; before each CHR set? Maybe that's screwing it up?

Jim

&quot;Get it right the first time, that's the main thing...&quot;

 

[jdegeorge]

Rienk

Better yet, just replace Chr(13) + Chr(10) with vbCrLf (the Visual Basic equivalent).

Jim

&quot;Get it right the first time, that's the main thing...&quot;

 

[rienk]

Access keeps messing up vbCrLf... keeps turning it into a field code, whatsoever...

 

[CosmoKramer]

Try this:

=IIf([vector_map] Is Not Null Or [sequence_info] Is Not Null, vbCrLf & "Related files:","") & IIf([vector_map] Is Not Null, vbCrLf & "Vector map: " & [vector_map],"") & IIf([sequence_info]Is Not Null, vbCrLf & "Sequence info: " & [sequence_info],"")