Runtime error 2176 The setting for this property is to long

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
 
G

Gary Miller

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
________________________
 
V

Van T. Dinh

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Runtime error '2176' listbox.rowsource too long 1
Run-time error '2176' The setting for this property is too long. 0
TextBox Text Property 1
Error 2176 - Setting for Property too long 1
Error 2176, Setting for this property is too long 1
Combo Box "Value List" - Run Time Error '2176' 3
++ List Box - Data Too Long?? ++ 2
run-time error 2176 9

Top