Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Access text box truncating memo field

Posted on 2012-03-13
7
Medium Priority
?
1,324 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

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 October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. 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

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

610 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