Text Box only displays first 255 char of Memo field... 1

[benwah]

Hi everyone

I have a text box on a form and the source control is a memo field. Problem is the text box will only display the first 255 characters of the memo field.

Is there a way to get around this?

Thanks in advance
ben

 

[hsitz]

Sounds strange to me. Do you have the text box stretched vertically as well as horizontally? Do you have vertical scrollbars enabled in the format properties of the text box? Are you sure the memo field really is a memo field? (i.e., that in design view it is of type memo and not text) -- Herb

 

[benwah]

Hi hsitz,

here is the basic lowdown of what happens and what i have deduced:

The text box txtAppraisal is unbounded. When an item in a list box is clicked the the onclick event for the list box runs the following code:

AppraisalTXT = AppraisalList.Column(1)

This tells it to populate the text box with what is in column 1 of the list box. If any changes are made to the text in the text box then it is saved using an SQL statement. There is nothing in this statement that touches the properties of the text box. I have had a look at the table and all the data is being saved, just not being displayed correctly by the text box.

Initially when the bug was reported to me i thought it was a simple matter of changing the required fields type from text to memo. It is now starting to be a pain!

Thanks again
ben

 

[scking]

Ben,

You are feeding all the text from a memo field into a column on a listbox. Listboxes have constraints on the amount of data they can hold. Also, I believe the column length may be truncated at 255. You may be trying to send a lot of data through a small pipe since you would be constrained by the Listbox.

Steve King Growth follows a healthy professional curiosity

 

[benwah]

Thanks Steve that is a very good point.... time to think up a work around now!