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

Problem with MS Word paragraph and character styles: format getting messed up 2
Runtime error '2176' listbox.rowsource too long 1
Setting language of a selected text in Office apps. 0
Runtime error and Ribbon_Get DCVisable error 0
ASK Field Formatting 1
Word 2016 - Difficulties Learning Style Creation/Application 0
Run-time error '2176' The setting for this property is too long. 0
Creating Custom MS-Access Input Masks -- Where can I find the codes to use? 0

Top