Solved

Access text box truncating memo field

Posted on 2012-03-13
7
1,256 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
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 150 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 350 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

839 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