Search code examples
vb.netms-accessoledb

TEXT datatype become MEMO in Ms.Access

Why did TEXT datatype in OleDbQuery become MEMO in Ms.Access? Here is the screenshot

OleDbQuery Result in Ms.Access

Please help...

Solution

  • You should use:

    .. "] TEXT(n)"

    where n is the size (max. length) of the field with a maximum for n of 255.