Folks
On my form I have a list box that contains some values that are too long for the width of the box. This looks scruffy. Is there any way to display only a specified number of characters and, preferably, append an ellipsis ('…')?
Remster
Folks
On my form I have a list box that contains some values that are too long for the width of the box. This looks scruffy. Is there any way to display only a specified number of characters and, preferably, append an ellipsis ('…')?
Remster
I doubt it remster. the box is one object. check out the 'column width' property, which is different than the actual 'width' property. what I do with mine is make the col width the same as the box width and make sure it is long enough for the longest value in the list...
I suspected as much. Thanks for giving it some thought anyway.
If you use a List with multiple fields (one to hold the actual value and another to hold the displayed text) it is quite possible to do. See the attached example for one way to do it with something like:
Code:Left([DisplayText], 10) & IIf(Len([DisplayText] > 10, "...", "")
Hurrah! I've put the code in the Row Source field rather than a separate query, but it seems to work fine:
SELECT Forms.ID, Left(Forms.[Form name],10) & IIf(Len(Forms.[Form name])>10,"...",""), IIF(Forms.[Current form?]=True,"Current version") FROM Forms ORDER BY Forms.[Form name];
Many thanks.
My pleasure