• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1345
  • Last Modified:

Access text box truncating memo field

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
HKFuey
Asked:
HKFuey
  • 2
  • 2
  • 2
  • +1
3 Solutions
 
Rey Obrero (Capricorn1)Commented:
are you using a query as record source of the form?

see this link

http://allenbrowne.com/ser-63.html
0
 
Luke ChungPresidentCommented:
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
 
Jeffrey CoachmanCommented:
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
HKFueyAuthor Commented:
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
 
Jeffrey CoachmanCommented:
still not sure why you are using a control designed to display "one" value, to display memo data...?
0
 
Luke ChungPresidentCommented:
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
 
HKFueyAuthor Commented:
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now