can I extract part of a 'memo' field into a 'text' field?

J

JK

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Write to a Memo Field 1
Text and Memo field concatenation - Line break (Access 2007) 4
Change the color of each capital letter in a rich text memo field. 0
Text to Memo 1
Formatting Memo Field Text 4
corrupted memo field in multi-table query 6
Enter new line in rich text memo field 4
Memo Field Text Hidden 2

Top