<div>
Or like this with the parenthesis:<br />
<br />
=[strHorseBarnName] &amp;&nbsp;IIf([strHorseRegisteredNam<wbr />e]=&quot;&quot;,&quot;&quot;,C<wbr />hr(13) &amp;&nbsp;Chr(10) &amp;&nbsp;&quot;(&quot; &amp;&nbsp;[strHorseRegisteredName] &amp;&nbsp;&quot;)&quot;)<br />
<br />
Or<br />
<br />
=[strHorseBarnName] &amp;&nbsp;IIf(Len([strHorseRegistere<wbr />dName])=0,<wbr />&quot;&quot;,Chr(13)<wbr /> &amp;&nbsp;Chr(10) &amp;&nbsp;&quot;(&quot; &amp;&nbsp;[strHorseRegisteredName] &amp;&nbsp;&quot;)&quot;)
</div>


Or like this with the parenthesis:

=[strHorseBarnName] & IIf([strHorseRegisteredName]="","",Chr(13) & Chr(10) & "(" & [strHorseRegisteredName] & ")")

Or

=[strHorseBarnName] & IIf(Len([strHorseRegisteredName])=0,"",Chr(13) & Chr(10) & "(" & [strHorseRegisteredName] & ")")

<div>
<div class="content wysiwyg-content">
The ControlSource for the text box in my report is: =[strHorseBarnName] &amp;&nbsp;IIf(Not IsNull([strHorseRegistered<wbr />Name]),&quot; (&quot; &amp;&nbsp;[strHorseRegisteredName] &amp;&nbsp;&quot;)&quot;,&quot;&quot;)<br />
<br />
How do I get the registered name to print in a line below the barn name (if it is NOT null)?<br />
<br />
I tried &nbsp;vbCrLf but that did not work.
</div>
</div>


The ControlSource for the text box in my report is: =[strHorseBarnName] & IIf(Not IsNull([strHorseRegisteredName])," (" & [strHorseRegisteredName] & ")","")

How do I get the registered name to print in a line below the barn name (if it is NOT null)?

I tried  vbCrLf but that did not work.

How do I add a line break in a report text box?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.