Mea culpa... That's not right. Under in view designer fields tab, select the memo field, then select the properties button. You can change the Data Mapping.Data Type option to char.

>Modify the view. Select the Query.Advanced Options menu item. There is an option to "Use Memo when field >=nnn". As long as the all memo len < nnn, it should show as a char field.
>
>>Drop an editbox control in your form and bound it to your memo field: thisform.Edit1.ControlSource = YourView.YourMemoField
>>
>>>How can a display a memo field in a view? I want to see the actual data in the memo field not just [memo].
>>>
>>>Thanks