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