Memo fields

[Aurora]

I am using Access 2000

In a Report - Can a Memo field be set up to show only the
last 5 lines within the Memo field? In other words, I only
want to see the last information within this field.

Does anyone know if this can be done?????

Aurora

 

[Janet Russell]

You might try using the Right() command: Right([name of
field], "characters to print"), replacing the words I've
entered with the name of your field and the number of
characters you want to print.