Display bottom of Memo Field

[drschlong]

Hi all,

Does anybody know how I can automatically display the latest contents of a memo field on a form. So for example if my Memo field displays 100 characters but I have 500 characters entered in to the field how do I auotmatically display the last 100 characters.

I would also need to do this on a report.

Thanks for any help you may be able to give.

Steven.

 

[smed]

Create another Text control of your form/report to display the last 100 character of the memo filedand specify its control source to:

=Right(memo,100)

(N.B. both the original memo field and the shortened emeo field must be present on the form/report, however the original memo field does not have to be visible)

HTH

Smed