Adding a Carriage return to a string 2

[slaman]

I want to add an carriage return to a string if it exceeds a certain length. I thought this would be easy (simply add a & Chr(13)) but for some reason, it displays a little black box instead of actually doing a carriage return. Any ideas?

 

[PhilipSchroevers]

Where do you try to display this string? On a report, in a text box?

 

[slaman]

It's for a textbox on a form.

[Text Box Name] = stringName1 + Chr(13) + stringName2

is basically what I am trying to do to have the stringName1 and stringName2 display on two separate lines.

 

[gwinn7]

Take your pick...

Chr(13) & chr(10) ' <--- Instead of just Chr(13).

OR

vbCrlf ' <--- Builtin carriage return

Example:

Me.txtBox = IIF(Len(Nz(Me.txtBox,&quot;&quot > 12, Me.txtBox & vbcrlf, me.txtbox)

Hope that helps.

Gary
gwinn7

 

[gwinn7]

Whoops! My example is missing a right parenthesis. Here is my example modified...

Me.txtBox = IIF(Len(Nz(Me.txtBox,&quot;&quot) > 12, Me.txtBox & vbcrlf, Me.txtBox)

Gary
gwinn7

 

[slaman]

Chr(13) & chr(10) worked wonders... the second one didnt.. I assume it's Access 2002 syntax again...

 

[izenenigmai]

I have a similar question, just backwards. I have a linked HTML file and when it's brought in, there is a carriage return in the field. Basically the carriage return is between the &quot;field name&quot; and the &quot;value&quot;(but both are in one field). Is there any way I can seperate the two within a query and have them in seperate fields?