I have a Memo field on a Table (no Format, Validation, Compression, IME and Plain Text) and input is cutting of at 255 characters. This is into the Table Field not through a form or anything else.
I have tried pasting more in - and the whole text shows initially - but when you review the field it has definitely cut back to 255 characters - checked in Word.
I have added a new Memo field to the same table and pasted 500+ characters - again it shows on pasting but not on reviewing - its back to a text 255 characters.
I have Memo fields in other databases that work exactly as expected but this one wont!!
Can some please explain whats happening and how I fix it
I have tried pasting more in - and the whole text shows initially - but when you review the field it has definitely cut back to 255 characters - checked in Word.
I have added a new Memo field to the same table and pasted 500+ characters - again it shows on pasting but not on reviewing - its back to a text 255 characters.
I have Memo fields in other databases that work exactly as expected but this one wont!!
Can some please explain whats happening and how I fix it