memo field

D

Dcbrown428

I thought I posted this, but can't find my posting so please forgive if this
is a duplicate. I have a field that I need to change from text to memo to
allow additional characters. I have gone in under table design and changed
it to memo, but it will still halt the characters at 255. What am I doing
wrong?
 
J

John Vinson

I thought I posted this, but can't find my posting so please forgive if this
is a duplicate. I have a field that I need to change from text to memo to
allow additional characters. I have gone in under table design and changed
it to memo, but it will still halt the characters at 255. What am I doing
wrong?
Click to expand...

I saw the post and replied to it so I'm not sure what's wrong!

Be sure that there is no Format or Input Mask defined for the field;
either will truncate it to 255 characters. Also, don't try to sort by
or group by the field in a query.

John W. Vinson[MVP]
 
D

Dcbrown428

Thank you for your help!

John Vinson said:
I saw the post and replied to it so I'm not sure what's wrong!

Be sure that there is no Format or Input Mask defined for the field;
either will truncate it to 255 characters. Also, don't try to sort by
or group by the field in a query.

John W. Vinson[MVP]
Click to expand...
 

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

disctinct query memo field 3
Macro to Select text from a point given to a specific word 2
Memo field 1
Memo text box 6
Make Table Query Truncating Memo Field at 255 Characters 1
insert memo feild into a memo field truncates at 255 characters - 4
Word 2016 - Difficulties Learning Style Creation/Application 0
Populate memo field with check box 7

Top