Text variable lenght

[coolg123]

Hi,
I've 3 columns next to each other and i've comma(,) between them.
because of the coulmns of variable length i see alot space b/w column and comma.
I know i can make the column dynamic to go number of lines vertically(with 'CAN GROW' property) can i make it dynamic length horizontally?


Thanks alot in advance.

CoolG

 

[dunlop1975]

What is the information that is being displayed? Instead of having 3 columns could you create a formula that output the data?

example:

{field1} + "," + {field2} + "," {field3}

if the data is numeric add a Totext() for each field
i.e totext({field1})

 

[dunlop1975]

sorry, left out a +

{field1} + "," + {field2} + "," + {field3}

 

[coolg123]

Thank you very much,
I feel so stupid after seeing the answer...


CoolG

 

[synapsevampire]

Also if you use & instead of +, you never need to convert data types, it does so itself.

{field1} & "," & {field2} & "," & {field3}

-k

 

[dunlop1975]

Thanks synapsevampire. I did not realize that. I've been working in CR7 (that syntax doesn't work)for the last 2 years and just started with CR11.