Making text in a text field display in columns

[evancooney]

Hello,

I have a text field that contains check boxes. On another layout, I have those check boxes that are selected represented as plain text.

However, the when the checked items are represented as plain text, they appear as one giant vertical column. IE

111111

222222

333333

444444

555555

How can i get them to display in seperate columns. IE

111111 222222 333333

444444 555555 666666

777777

Thanks

[Chuck]

What are the rules? You have broken the single column into three columns. Is that what you want? Or should it be broken into three rows?

Basically, when multiple items are checked in a checkbox field, each item is separated from the others by a carriage return. By converting the correct carriage returns into tab characters instead, and setting up the field to have tab stops at the appropirate places, you can do what you want. But determining which carriage returns to convert is where the rules come in. For instance, your example would convert the first, second, forth and fifth carriage returns to tabs, but left the third and sixths as returns. If that's the rule, then it can be translated to a calculation. Also, how many items are available in the checkbox?

Chuck

[dondawg]

What is a tab character in a text field? Or should I say how do you do the conversion?

[BobWeaver]

The easiest way to use a tab character is to put one in a global container field (call it gTab for example). Then whenever you want to use it in a calculation, just refer to the field. Example, to replace carriage returns with tabs you would use:

Substitute(TextField, "