Seems like it should be doable. How do i pull just the first 100 characters (or just some number) of a memo field that has say 2000+ chars in it. Basically just want to show the beginning of a news story, not the whole thing.
What DB are you using? If its access you can just mod your SQL statement to look like this:<BR><BR>Select left(myMemo, 100) as smallMyMemo from myTable<BR><BR>Mark Ewer<BR>Web Application Developer, MCSE<BR>LSI (http://www.lsijax.com)