Limit characters AND line feeds in memo control

[RDSJMS]

I have a data entry form with a memo control physically sized to match the allowable space for this information when printed on a report.

Basically, I need to be able to stop the user from further input when the cursor reaches the lower right corner of the memo control. Beeping when reaching the limit is acceptable, but a pop-up message would be ideal.

I have not been able to find a solution that will limit the amount of text displayed in the memo control that will also include however many LF's a user inputs. All of the search results refer to only limiting the number of characters and do not take into account LF's.

I am new to Access and would appreciate all suggestions.

 

[RuralGuy]

Maybe this link will be useful: http://www.lebans.com/limitcharsmemo.htm

 

[RDSJMS]

Thank you, but this only limits the total number of characters. It counts the line feeds, but does not limit them.

I need both the characters and the LF's to be limited because the report that is derived from the data the user inputs in the form must be only one page. It's a political thing more than anything. That's why I don't set the control Can Grow/Can Shrink to Yes.