toshii1222
Programmer
Hi,
Is it possible to sort a memo field? If it is possible, how can I do that?
Is it possible to sort a memo field? If it is possible, how can I do that?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sort Memo field??
- Thread starter toshii1222
- Start date
- Status
Hi Toshii,
The only options for a memo field is to display it. No formulas, etc, can be written for it - to sort, select, etc.
Not a very handy field! Some people chop this field up at the database level into many fields - all less than 255 chars therefore making them string fields - then concatinate them back together in the report - thereby allowing you to sort on string field #1 - etc.
I hope this answers your question!
Cheers,
paulmarr
The only options for a memo field is to display it. No formulas, etc, can be written for it - to sort, select, etc.
Not a very handy field! Some people chop this field up at the database level into many fields - all less than 255 chars therefore making them string fields - then concatinate them back together in the report - thereby allowing you to sort on string field #1 - etc.
I hope this answers your question!
Cheers,
paulmarr
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question