Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Memo Field and number of characters 3

Status
Not open for further replies.

ribbons

Technical User
Apr 26, 2007
113
US
Hi all,

I have an Access Db that contains a memo field with rather lengthy text entries. I also have a form on which I want to display the info in the memo field in a text box. I believe I have read that text boxes will accomodate up to 64,000 characters from a memo field. But for some reason, I can only get a limited number of characters to display in this text box. I can look at the table itself and see the complete memo entry. So, am I missing something here?

ribbons
 
Queries sometime truncate memo fields to 255 characters, not always! Allen Browne has a brief paper here on the subject with some workarounds.


The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!
 
have you tried to crear a NEW text box as a test (even on a different form) to see if it display what you require.


Never give up never give in.

There are no short cuts to anything worth doing :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top