Hey folks: I have a memo field in a table, that I need to take the
last 200 characters of and dump into a text field.

But none of the text functions I've tried will work with Memo fields.

Is this not do-able?

Thanks.
jk

I have no problems with using Right([FieldName],200). You should be able to
use this in an update query. Also make sure your text field in the table is
set to handle 200 characters, access usually defaults to 50.

"JK" wrote:

> Hey folks: I have a memo field in a table, that I need to take the
> last 200 characters of and dump into a text field.
>
> But none of the text functions I've tried will work with Memo fields.
>
> Is this not do-able?
>
> Thanks.
> jk
>
>