Memo Field & List Box

[Guest]

2 questions for everyone:

1. How many characters can a memo field store?

2. I have a list box on one of my forms. The box show a call history (Acct#,
Date, Time, Notes) For my notes section I have it setup as a Memo field.
Below my list box the user can input the information, click save and then it
updates the box above.

What is happening is that the notes being typed into the "notes" section are
sometimes too long to be displayed. Is there a way to be able to click on a
filed in a list box and display the entire field with wrap-around text or
something like that?

 

[Guest]

Last that I remember was 2 meg.

It seems you are using the list box in a way it was not intended. The kinds
of data you are putting in a memo field would best be in separate fields -
Acct#, Date, and Time. Date-Time is best in a single field. Just put
Notes/Remarks in the memo field.

Use a TextBox and size it for good visual diosplay for the memo field.