Solved

Access text box truncating memo field

Posted on 2012-03-13
7
1,267 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
Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

 

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

749 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