Text Box only displays first 255 chars of memo field

[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

 

[Maquis]

Do you have any formatting in the format property of the text box? If so, get rid of it. That will turn the box from a memo field into a text field and therefore impose the 255 limit. Maq B-)
<insert witty signature here>

 

[benwah]

thanks for the reply but no i dont have anything in the format area of the text boxes property....

any other ideas... anyone...

ben

 

[Maquis]

What is the record source for this form? Is it a query? Is there any formatting in the query? Maq B-)
<insert witty signature here>

 

[benwah]

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

 

[Maquis]

You're memo field is a column in a listbox??? Yeeouchhh! I'm surprised Access allows such a thing. I'm sure Access has changed the field to a text field in order to put it in the listbox.

Take the field out of the listbox and just use the box to hold a record id that you can click, then write the VB code to display the appropiate record in your form.
Maq B-)
<insert witty signature here>

 

[benwah]

thanks Maquis, i'll give that a go.

ben