Linked View Showing Text 255 instead of Memo for VarChar(4000) field

[hwkranger]

I have a view that is truncating a field. It's a comments field from a SQL server 2k as a VarChar(4000)

If I look at the table def in the linked table, it shows as MEMO, but if I look at the view it shows as text(255)

I tried relinking the view. I haven't cast the field in the view, but I don't think this is needed.

Does anyone know why this is happening, and how I can fix this?

thank you very much.

Randall Vollen
National City Bank Corp.