In our database we have taken to using varchars on memo type fields
that are a finite size rather than just using a blob and allowing
unlimited size.

The problem I have is that if a field let say a Varchar(1025) gets
completely filled and the user inserts some data at the beginning of
the string and doesn't realize that the string is too large then the
system gives a "Stream Write Error" and truncates the data at the end
of the string to only allow the max length of the string.

This is fine except that the user doesn't know that the string is too
long until it is too late. Is there a way to have the system prevent
this problem and tell the user that the string is too long before it
truncates the string.

I don't want this behavior on fields that are Varchar(255) or smaller
just the ones that are larger than 255 and IBO recognizes as
TMemoFields. Is there something that can be done with the BlobType
property or some other property. It looks like it defaults to a
BlobType of ftMemo.

Thanks.