3163 The field is too small to accept the amount of data

[afr0ninja]

I have 3 seperate forms that I've combined into one. I have a combo
box set up where it drops down and you select what form you want to
use. The other 2 forms hide, the one you select shows.

When you utilize the seperate forms, they work perfectly. After
combining them, I started getting an error with the memo fields. 3163
The field is too small to accept the amount of data you attempted to
add try inserting or pasting less data. This appears whenever you try
to save the record you are on no matter if you type 1 or 100
characters. I'm pretty limited in my knowledge of forms, if anyone
has any ideas of what could be causing this, I would appreciate it.

 

[Allen Browne]

If you have the same memo field open for editing in multiple forms at once
(at least in Access 2000 and later), you can run into a multi-user error,
even if you are not editing in both forms at once.

If that is the problem you are experiencing, you might be able to work
around the problem by creating a query that does not include the memo field,
and use that query as the RecordSource for the form where you don't need the
memo.

Or there may be other possibilities such as using the zoom box (Shift+F2) or
an unbound popup form for enlarging the memo for editing.