Variable height field

[phoggy]

Hi all,

How can I vary the height of a memo field according to the content?

Thanks for any suggestion.

 

[synapsevampire]

Please post your software version.

Then explain what based on it's content means to you.

You can right click it and select format field and select can grow which will make it expand downwards.

-k

 

[phoggy]

Sorry forgot again, using CR XI Professional and MS SQL 2005.

I have Can Grow set to 3 (max I can put), but there can be fewer rows than 3 and those lines that don't have content show as blank lines. I'd like to eliminate the blanks.

Thanks

 

[synapsevampire]

It conditionally grows, even when you place 3 as the maximum, it doesn't mean 3 as the minimum, it doesn't create additional lines unless there's data, so you might have spaces or carriage returns, or something else in there.

Make sure that you leave the size of the field itself to only one line, don't increase the height of it other than using Can Grow.

To make sure you don't have CRs or spaces within, try using a formula instead of the field, as in:

replace(trim({table.field}),chr(13)," ")

Then also test the length of th field using:

len(trim({table.field}))

in another formula alongside to aid in discovery.

-k