usage of Memo field

[penfold1992]

I want to be able to store large amounts of text (possibly) in a memo field but I am not aware what memo field can allow.

Id like to be able to enter paragraphs of text with the use of line breaks and also indents (can be done via the "Enter" key for line breaks and either "TAB" or multiple spaces for indent I guess)

I would like to be able to keep this formatting in the database as well as keeping the format when I'm extracting the data too.

I am thinking about adding the data to the database via a form with a large text box however im not sure if I can have a box that auto scrolls with the cursor as you get to the end of the box and continue typing. For initial data entry however, it would be nice to view or edit in the table view (for the admin of the database)

Is there a way I can "pop out" the data in the memo field to view the data in the box or will I have to expand the row height in order to see the information?

 

[billmeye]

If you are using 2007 or later you can have a rich text memo field that will store formatting characters. I believe the limit for a memo field is equal to the actual DB limit of almost 2 Gig, obviously not needed for just a few paragraphs. If you want a very large box for typing but don't want to have a very large form that scrolls down the page, use a tab control and place the memo text box on it's own tab.

 

[SOS]

If you are using 2007 or later you can have a rich text memo field that will store formatting characters. I believe the limit for a memo field is equal to the actual DB limit of almost 2 Gig, obviously not needed for just a few paragraphs. If you want a very large box for typing but don't want to have a very large form that scrolls down the page, use a tab control and place the memo text box on it's own tab.

A memo field can handle 65,354 characters in a text box by means of the usual bound controls. If you need more than that, you can do it if you use VBA.