memo data type in a data grid?

Brando Rodriguez

I use a memo field (with a memo data type) and insert it in a data grid, along with a set of other data, text, date, currency, etc.

 

But when the info typed in the memo field, all the data is "shrinked". Is there a way that can be desplayed as the way it was typed?

 

Example

 

Memo field:

a. Function 1 is when.....

b. Function 2 is when...

c. Function 3 is when...

 

after is instered and displayed in a grid (text data type)

 

a. Function 1 is when..... b. Function 3 is when.... c. Function 3

is when...

Brian Mellert

I suspect it may be related to how your 

is set.  This setting is system wide.  (It would be nice if this could be set grid by grid or form by form.)

 

If its 1, as it is above, means data cells will display in HTML format.  This means \r\n will not be rendered visually, though the characters are still there.  I got around this, when needed, by coding my BO to read the column and replace \r\n with
and it displays correctly.

 

I don't recall how it displays before this setting was enabled, which should be equivalent to a value of 0.  However, if I recall it didn't line break then either.  I'm not sure how to get around it in this place.