Prev: want to link specific records in access to cells in excel
Next: Autokeys macro doesn't work in code window
From: mary3416 on 7 May 2010 15:04
I cannot make the field size increase past 255. Data is cut off
From: Douglas J. Steele on 7 May 2010 15:23
Sounds as though you're using a Text field, not a Memo field.

Text fields cannot exceed 255 bytes.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"mary3416" <mary3416(a)discussions.microsoft.com> wrote in message
news:AFE0CB52-7957-46AD-A9A6-A591E8246A13(a)microsoft.com...
>I cannot make the field size increase past 255. Data is cut off


From: John W. Vinson on 7 May 2010 16:10
On Fri, 7 May 2010 12:04:03 -0700, mary3416
<mary3416(a)discussions.microsoft.com> wrote:

>I cannot make the field size increase past 255. Data is cut off

If it is indeed a memo field, make sure there is no Format property specified
for the field either in table design, query design or the form textbox. Any
format will truncate the field.
--

John W. Vinson [MVP]
 | 
Pages: 1
Prev: want to link specific records in access to cells in excel
Next: Autokeys macro doesn't work in code window