Memo Field

[Aurora]

I am using Access 2000.

In a report that contains a memo field is there a way to
limit the number of lines that the memo field shows to a
specific number? Or preferably, can you configure the
field to only print the last 5 lines that are in the memo
field?

Aurora

 

[Van T. Dinh]

See Stephen Lebans' LimitCharsMemo:

http://www.lebans.com/limitcharsmemo.htm

 

[Aurora]

Thank you for answering my question, But I don't think I
understood what you were telling me. I went to the web
site you suggested and downloaded the db. I then went
into one of the records and added a lot of verbage into
the memo field and created a report. The report printed
all of the verbage. I don't know where the setting are on
the form properties (or are they on the report properties)
to make the changes indicated on the form (right hand
side). Can you make this any clearer for me??


Aurora

 

[Van T. Dinh]

On the RHS of the Demo Form, you can change the limit on number of
characters entered.

If you want to understand how it works, you need to open the Form in
DesignView and learn the code.

OTOH, if you only want to print, says, the last 2 paragraphs of the Memo
Field value in the Report, you can write a custom function using InStrRev()
to find the position of the second hard Return and then use the Mid()
function to select only from after the second hard Return to the end of the
Memo Field value. Remember that they are hard Returns and Access TextBox
wraps lines so 2 hard Returns can be a lot more than 2 lines in the TextBox.

(Check Access VB Help on the InStrRev() and the Mid() function.)

Sorry, I don't know how to make it exactly 5 lines printed.