Right end of value list in narrow field?

[Peter]

Hi everyone,

Please bear with me if I am missing something obvious, but I can't work out how to display the final - rightmost - characters of the items in a value list for which I can only provide a narrow field on my layout.

It needs to be a pop-up menu, which will display the full 60 character contents of each item on the value list when the user is making or changing a selection, but which will only display the * last * 20 characters of the selected item when the menu has popped down again.

I should be most grateful for any help with this.

Peter

[comment]

only display the * last * 20 characters of the selected item

I don't think that's possible: if the field can show only 20 characters, and the item is longer than that, the remaining characters will be wrapped to subsequent line/s.

You could add a calculation field =

Right ( YourField ; 20 )

and place it over the popup.

[Peter]

Yes, that does the trick well enough. Thank you very much for your help.

Peter