Re: max memo field

On Sat, 30 Dec 2006 23:04:00 -0800, balu
<balu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

how to make an memo field to hold an book size date
present it can hold only 255 charactes

A Memo can hold more than 255 characters - UNLESS you have a Format,
Input Mask, or Sort defined on the field. Make sure you're not
specifying one of these properties on your Form or in the table
properties of the field.

That said... a memo will hold up to 2 GByte, if you populate it
programmatically, but only 65536 characthers if you're typing them in.
That's a pretty thin book. If you really mean to store book-type data,
I'd really suggest storing the text (probably with nice formatting,
chapter heads, etc. etc.) in an external Word or Publisher document,
and store the path and filename to the document in your Access table
(either as text or as a Hyperlink field).

John W. Vinson[MVP]
.