Data cut off in view

[fishkake]

Hello again...

I assume Pascal is reading this, and he already knows what I'm talking about, but for anybody else:

One of my entities (forms) in a database is "Region" which consists of a region name (eg. Western Europe) and a list of countries (selected from a master list in the profile document).

I have a view which displays these regions, with an twistie for each region name displaying the countries. But "word wrap" (as Notepad calls it) isn't working, which means the user has to scroll to the right for miles. Even if I make the column smaller, and enable multiple lines, it forms four lines and cuts off mid-word at the end of the column.

This is a terrible explanation, hope somebody can help!

 

[fishkake]

Update - the problem seems to be that it will only go as high as four rows. I've enabled 9 rows per entry, and even if I turn the "Shrink rows to content" off, it only creates four lines of countries (cut off sometimes mid-letter!) and then 5 empty lines.

 

[fishkake]

OK, I have now solved this problem, seems a strange feature in Notes.

The view will only create a new line where there is a space, so if the seperator is a semicolon, the only line breaks are where the spaces appear in countries, such as Sierra Leone or United Kingdom! Changing the seperator to a space makes it look a bit less pleasing, but it solves the line problem.

 

[pmonett]

Sorry I'm late on this one, but it looks like you're really having fun ;-).

Pascal.

 

[fishkake]

Yes. Fun.

I wrestled with this for ages - after I said I'd solved the problem I suddenly realised that "Sierra Leone" was being sorted, such that Leone appeared halfway down the list, and Sierra at the end!

All in all, I managed to sort it out by sorting the column in the view, rather than using @Sort which I had been doing before.

I've got to the point where I've finished the databases now, and they just need tidying up. nfortunately this takes forever!!