max memo field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

It sounds as if you have a "text" field and not a "memo". Go back to the
table design and change the field to a Memo.

When changing any field format you MUST make a "backup" 1st - just in case.
 
how to make an memo field to hold an book size date
present it can hold only 255 charactes
Click to expand...

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]
 
Back
Top