Convert Memo to Text

Question

Exact Duplicate of : http://stackoverflow.com/questions/1112954/convert-memo-to-text

Hello, I've got an msaccess database which have been created in MS Access 97. I only have access 2003 and 2008 in my computer. so I've converted the database into access 2003 format.

The problem I have is that I have a table named 'tblItms_F001' in the database with a column named 'stemtext' which is in memo datatype. I just want to be able to read the text inside that column in every row. (have around 150 rows only). Moreover I don't know VB and haven't used access before as databse. I've used C#, Java and mssql and oracle. Please let me know how can I just be able to read that text. When I try to open the table in access datasheet view it shows the column with wierd text into it. For example following text appears in the first row's column data

%,9m$>m,#m#9$94m

Note : the field contains just questions which are usually not large than 256 characters

Answer 1

Trying using/creating a repeating form instead of a datasheet view. (It's been awhile, but I think the Form Wizard should make quick work of this).

Answer 2

I've tried creating a repeating form using MS Infopath but when I perform the query it gives the same text in the result textboxes. A text which appears like this :

%,9m$>m,#m#9$94m