Field size to small for amount of text

[Guest]

I have a text box that i enter data into, the table data is set to memo which
says that i can have around 64000 characters, but when i enter the text it
appears that only 150 or so characters can be entered, what can i d to
increase the amount of data that i can enter

 

[Van T. Dinh]

I think the TextBox dimension can only show about 150 characters but if you
keep entering, the Text will scroll to accomodate the new text.

You can resize the TextBox and use the Vertical ScrollBar Property of the
TextBox. See also Stephen Lebans' Autosize_Textbox:

http://www.lebans.com/autosize_textbox.htm

 

[missinglinq via AccessMonster.com]

" it appears that only 150 or so characters can be entered"

Can you actually only enter 150 characters or so, i.e. does Access stop
accepting input, or does it appear only 150 characters have been entered
later. Appears where? Looking at the table directly? When viewed thru a form?
When viewed thru a query? Same question about how you enter data: thru table
or form?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[Guest]

I can enter the text ok, it appears in the textbox, but it will only aloow
about 150 characters, i have made textbox allowed to grow and i did add side
scroll bars, this still didn't fix it, when i enter the data, it enteres ok,
when i save it only saves the first 150 characters and when i check the
table, it only has the first 150 characters also,
--
Many Thanks
Kevin

I think the TextBox dimension can only show about 150 characters but if you
keep entering, the Text will scroll to accomodate the new text.

You can resize the TextBox and use the Vertical ScrollBar Property of the
TextBox. See also Stephen Lebans' Autosize_Textbox:

http://www.lebans.com/autosize_textbox.htm

 

[Van T. Dinh]

The CanGrow only works on printing of the Form so it is not related in this
case.

Are you saying that you enter a really long text string and you can scroll
up and down the text with the TextBox vertical scroll bar but when you save
it, only about 150 characters are saved in the Table?

Have you scrolled in the Datasheet just in case there are other text after
what you see?

IIRC, this only happens when you use "Group By" (but then the rows hence the
Form isdata is not updatable) or you sort records by the Memo Field as
Access/JET needs to convert to a Text value to do comparison.

--
HTH
Van T. Dinh
MVP (Access)

I can enter the text ok, it appears in the textbox, but it will only aloow
about 150 characters, i have made textbox allowed to grow and i did add
side
scroll bars, this still didn't fix it, when i enter the data, it enteres
ok,
when i save it only saves the first 150 characters and when i check the
table, it only has the first 150 characters also,