Ellipses (...) not displaying in forms or queries

[HFloyd]

Hello, I'm not sure if anyone else has had this problem...

I have a form that looks up data from a query and displays it in a text box. The data it is looking up consists of a shortened version of a memo field's text. ([ShortNote]) Since it is a shortened version, I want to display it with an ellipse at the end. For the life of me, I cannot get the ellipses to show up!

I have attempted this in the query, and in the text box on the form. The expression for the text box is:

=DLookUp("[ShortNote]","qryArticles-LegalNotes","[ArticleID]=" & [ArticleID])&"..."

I do not recieve an error, just the ellipses are not showing up, just the ShortNote text.

Do ellipses have some special meaning in expressions that would prevent them from displaying? I haven't been able to find any information about this.

Thanks,

Heather

http://www.floydinnovations.com

 

[HFloyd]

Oops! Nevermind... I figured out what was wrong (My [ShortNote] field was ending in a linebreak!) Duh!!!

http://www.floydinnovations.com