memo text in a text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm showing a text from a memo field in a text box on my form.

But, this text is cut there, I think, because of some default restrictions
on a number of spaces in the text box.

How could I increase it to have enouhg space to show all text in the text box?

Thanks
 
I'm showing a text from a memo field in a text box on my form.

But, this text is cut there, I think, because of some default restrictions
on a number of spaces in the text box.

How could I increase it to have enouhg space to show all text in the text box?

Thanks
Click to expand...

Just be sure you're not setting any Format property on the memo field
or on the textbox; also, be sure you're not sorting or grouping by the
memo field. All of these operations truncate the memo to 255 bytes.

A Memo field will ordinarily allow you to enter up to 65536
characters; you'll usually want a big textbox with its scrollbar
turned on.

John W. Vinson[MVP]
 
Thanks a lot, John.
I've checked it out. The final query associated with the text box shows a
full text in the memo field.

But, the text box on a form shows a cut text.
There is no any formatting on the text box.
 
I've forgotten to mention that I'm using the following to assign the memo
text to the text box:

Me.txtNotes = Forms!frmAnotherForm.cboBox.Column(6)

May be something wrong here?
 
Thanks a lot, John.
I've checked it out. The final query associated with the text box shows a
full text in the memo field.

But, the text box on a form shows a cut text.
There is no any formatting on the text box.
Click to expand...

What's the Recordsource of the form? Is it a Totals query, or does it
sort the data?

It is quite possible that this *form* is corrupt. Try creating a new
form (a simple one, just one textbox bound to the memo field, using
the table as the recordsource); does it have the same problem?

John W. Vinson[MVP]
 
Alex said:
I've forgotten to mention that I'm using the following to assign the memo
text to the text box:

Me.txtNotes = Forms!frmAnotherForm.cboBox.Column(6)

May be something wrong here?
Click to expand...

Yup, a ComboBox column cannot contain a memo field. It will truncate at 255
characters.
 
Me.txtNotes = Forms!frmAnotherForm.cboBox.Column(6)

May be something wrong here?
Click to expand...

Yep. A combo box cannot contain a gigabyte of data in each row - but a
memo field can. The memo will be truncated to fit.

Instead, find the value of the memo field directly: if the bound
column of the combo is the unique ID of the table record containing
the memo, set the Control Source of txtNotes to

=DLookUp("[memofield]", "[tablename]", "[ID] = " &
Forms!frmAnotherForm!cboBox)


John W. Vinson[MVP]
 
Back
Top