Skip to content

A read-only, multi-line-enabled custom field built with a Select Statement using CHR(13) to insert line breaks (for displaying a multi-line address) shows everything on a single line in the client, even though pasting the same text into Notepad shows the carriage return is genuinely there.

Answer

Use CHR(13) || CHR(10) together (carriage return plus line feed), not CHR(13) alone — comparing how a genuine multi-line address (like one pulled from Customer_Info_Address) actually renders at the byte level confirms it uses both characters together, not just a bare carriage return. Concatenating both characters at each line break in your Select Statement is what actually produces a visible line break in the rendered custom field.

← Browse Developer Studio, deployment, and upgrades questions