Graphics

Hello,

I am building a few scences that are pulling data from a SQL database that has volunteers entering in the data. As you can see in this case they mistakenly entered in a few line breaks that Auto Squeeze is ignoring. I'm new to Xpression but is there a easy scripting/visual logic setup to force any thing that datalinq pulls to fit in the bounding box I specify?

Thanks!

I'm wondering if there might be a script to basically ignore a  line break. But that is above my knowledge ceiling.

Does Trim() remove line breaks? If it does, you could try either setting the text fields to trim(text) in event script, or you could make your actual database trim the entries somehow.

The VBScript trim() function only removes whitespace on the left and right of a string, so I don't think it will remove line breaks in the middle of other non-whitespace characters. Can you just use the Replace function on the string to get rid of them (replace line break characters with empty strings)? You might need to account for both Linux (vbNewLine) and Windows (vbCrLf) styles.