
Access, VB, and DAO problem with a Memo Field
I have a problem passing a query from an Access database to VB. I am using
DAO to connect to the database. I have a memo field that if I do a regular
select (or just return it in a query) it comes thru OK, however, if I run a
function/macro (don't know the correct term) in the query it cuts the text
of the memo field at 255 characters (the rest of the memo is garbage). The
garbage is the same so it appears to be reading the memory in the same place
(next record?). The same query appears fine in Access (no garbage). I can
not see anything wrong with my VB code, it is the same in displaying in a
text box, msgbox, debug window, or label.
The following function/macro causes the problem (Table1 is the table, ID is
a primary key and MemoField is the memo field of course, this was a test
line to see if it was my code or if it always happens even on another
machine).
ReturnMemo: IIF([Table1]![ID] >= 1, [Table1]![MemoField], "")
Has anyone ever experienced this before or know how to fix it? I can not
find anything in the MSDN Library nor on the internet about it.