Form recognizing hard carriage return

[JE]

I created table whereby certain fields are concatenated. Between the
concatenated fields, a hard carriage return was placed (e.g., vbCr).

When I place the results in a form, the carriage return is displayed as a
small square between the fields. Is it possible for the form to apply the
hard carriage return, thus stacking the fields?

Thank you.

 

[SteveM]

Try using Chr$(13) instead of vbCr.

Steve

 

[Douglas J. Steele]

Access needs both a Carriage Return (Chr$(13)) AND a Line Feed (Chr$(10)),
in that order.

In VBA, you can use vbCrLf instead to produce the same characters.

 

[John W. Vinson]

I created table whereby certain fields are concatenated. Between the
concatenated fields, a hard carriage return was placed (e.g., vbCr).

When I place the results in a form, the carriage return is displayed as a
small square between the fields. Is it possible for the form to apply the
hard carriage return, thus stacking the fields?

Thank you.

Use vbCrLf instead of vbCr. You may need to run an update query updating
Chr(13) to

Chr(13) & Chr(10)


John W. Vinson [MVP]