Convert Memo to Text

Question

Exact Duplicate of : 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

exact duplicate posted one (1) hour ago -- which has two (2) answers: http://stackoverflow.com/questions/1112954/convert-memo-to-text — mechanical_meat, Jul 11 '09 at 05:56
@Jay: reposting your question multiple times will not get it answered any faster (probably the opposite in fact) — Mitch Wheat, Jul 11 '09 at 06:00
even after posting it twice I didn't get a proper answer of the question. — jay1648, Jul 12 '09 at 04:21
The problem is that the question is completely unclear since you don't describe the context in which you're using the data and getting unexpected results. — David-W-Fenton, Jul 13 '09 at 23:00

score 1 · Answer 1 · answered Jul 11 '09 at 05:54

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).

answered Jul 11 '09 at 05:54

Jamo

3,238
6
40
66

As I stated above haven't used access or VB before. Would you please explain it or suggest an article on how to do this ? Thanks for your response – jay1648 Jul 11 '09 at 05:57
Check out http://office.microsoft.com/en-us/access/HP051876411033.aspx, or do some searches about "how to create a form in Access" -- should be a number of tutorials out there to get you started. – Jamo Jul 11 '09 at 06:15
If you're not using Access, why are you tagging your question as MS-Access? If all you're using is Jet/ACE, then you need to reword your question to indicate that, as well as indicating what programming environment you are using to access the Jet/ACE data. – David-W-Fenton Jul 13 '09 at 23:01

score 0 · Answer 2 · answered Jul 13 '09 at 05:58

0

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

answered Jul 13 '09 at 05:58

jay1648

76
1
6

Convert Memo to Text

2 Answers2