Runtime error 2176 The setting for this property is to long

  • Thread starter Thread starter Kevin Davis
  • Start date Start date
K

Kevin Davis

Can I get some thoughts on this. I am trying to fill a
text box from a query and it works some of the time. How
can I set the property of the text box to allow more
text. Can someone tell me the character limits?

Aloha,

Kevin
 
A text box is limited to 255 characters. If you need to go
beyond that you'll need a memo field that is good to around
64k of data.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
A TextBox Control can display 64K characters.

A Text Field can have up to 255 characters.

A Memo Field can have 64K characters in general (see Access Help for special
note).

However (guessing your problem here), when you use Group By or Order By, etc
.... in the Query which includes the Memo Field, JET database cannot compare
or sort (???) the Memo Field and truncates Memo Field to be similar to Text
Field and thus the values of your Memo Filed are truncated to 255 characters
 
Back
Top