text vs. memo field

[father]

Are there any other advantages in using a text field verses a memo field other than memory allocation? Memory allocation seems like such a small issue these days.

 

[KenHigg]

Hum...

The biggest reason(s) for one vs the other stem from a data modeling / normalzation perspective. There are some other technical reasons, like having the ability to sort, etc...

Can you give an example of the data in question that you wish to store?

 

[father]

example of text field

I collect quotes and teachings. Many times the info is greater than 255 characters. I have a VBA program that I copy clipboard info and seaparate the first 255 character or less, always ending in a ".", ",", "!", etc. and copying the remaining data automatically to a memo field.

How would this affect searching, sorting, etc. if I just had a memo field?

 

[KenHigg]

Hum... You should still be able to search on a memo fld...

I think I would do this as a memo fld as it really doesn't make any sense to try and break it down any further...

(Unless I'm missing something... )