?
Solved

Access text box truncating memo field

Posted on 2012-03-13
7
Medium Priority
?
1,303 Views
Last Modified: 2012-08-14
I have a list box and when clicked shows the content of a Memo field, unfortunately the data is truncated and some text is missing.

Does anyone know how to display the full content of a memo field on a Form?
0
Comment
Question by:HKFuey
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 450 total points
ID: 37714279
are you using a query as record source of the form?

see this link

http://allenbrowne.com/ser-63.html
0
 
LVL 10

Assisted Solution

by:Luke Chung
Luke Chung earned 1050 total points
ID: 37715405
I think a text box on a form shows up to 32K, so if the contents of your memo field is smaller than that, it should be fine. If there's a problem where only the first 255 characters are shown, it's probably due to a query truncating the memo field before it gets to your form.

When you say your list box is selecting the data to display, how does that work and could it be truncating it there?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37715668
A listbox is not designed to display "Memo" data.
1. Can you explain what your are trying to accomplish here?
2. Can the field be converted to "text"
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 

Accepted Solution

by:
HKFuey earned 0 total points
ID: 37715705
OK, thanks for the input.

I got round it by looking up the key field on the form and returning the memo data to the text box from the data.

Sql = "Select KeyField, MemoField From MyDb where KeyField=me!Keyfield
set Rst=Dbs.openrecordset(Sql)

Me! MemoField =Rst!Memofield
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37715733
still not sure why you are using a control designed to display "one" value, to display memo data...?
0
 
LVL 10

Expert Comment

by:Luke Chung
ID: 37716053
Create a form to display the memo field from the MyDB table.

Make it a subform in your main form with the ListView.

Create a master child link between the form and subform using the ListView as the master I(assuming its value is the KeyField), and the child link field as the KeyField from the MyDB table.

The subform should refresh when the list view selection changes.
0
 

Author Closing Comment

by:HKFuey
ID: 37734442
What I wanted was to click a row in a list box and show all text in the memo field in a square box on the form (as the memo data is easier to read in a square box instead of a long line)
Thanks all for the help
0

Featured Post

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question