Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Data cut off in view

Data cut off in view

Data cut off in view

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!

RE: Data cut off in view

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.

RE: Data cut off in view

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.

RE: Data cut off in view

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


RE: Data cut off in view

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!!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close