TextBox Bound to Memo Filed displays the first 255 Chr

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SS - 10 Jul 2007 11:52 GMT

hi everyone

I have a "Notes" field which is set on the table as a MEMO field. The notes
field is loaded into a form (bound) .the "Notes" field contains more than
255 characters. However, the "Notes" field (which is already a memo field
type bound to textbox) the textbox cuts off all data after 255 characters.
please help

thanks

Wael

Reply to this Message

Allen Browne - 10 Jul 2007 15:41 GMT

If the form is based directly on the table (not on a query), you probably
have something in the Format property of the text box on the form, or in the
Format property of the field in the table. Eliminate whatever is in the
property.

If that is not the issue, see:
Truncation of Memo fields
at:
http://allenbrowne.com/ser-63.html
for other possibilities.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> I have a "Notes" field which is set on the table as a MEMO field. The
> notes field is loaded into a form (bound) .the "Notes" field contains more
[quoted text clipped - 6 lines]
>
> Wael

Reply to this Message