Distinguishing between Text and Memo are as follows:
| Text | Memo |
| It is used for relatively short entries. | It is used for long text paragraphs. |
| It can store upto 255 characters only. | It can store upto 65536 characters. |
| It uses field size property to control the number of characters. | It does not use field size property. |
| e.g. Emp_name | e.g. Emp_description |