Characters beyond 255 in a memo field

  • Thread starter Thread starter Jim Pockmire
  • Start date Start date
J

Jim Pockmire

Is there any way to access the characters beyond the 255th in a memo field?
e.g. I need to create a substring of character positions 300-305. Are there
any work arounds? The info is being imported from an Excel spreadsheet.
 
Not sure what you mean. Memo fields can contain more than 255 characters,
and you can "access" them. What problem are you encountering?
 
Perhaps you are seeing this: memo fields can appear truncated in queries when
you are grouping by the memo field. In this case, try changing Group By to
First, and it will show the entire contents. I believe Access can only group
by the first 255 characters.
 
there's an interesting discussion going on about this topic. Go find it a few
days back in this group.
 
I am trying to extract a sub-string from a memo field. The memo field is 500
characters long and I am trying to extract the 300th to 305th characters as
a string. Thus far I have not been able to read the characters with what I
have tried.
 
To clarify, I am using the Transferspreadsheet method and am able to import
the data as memo fields. And I can see all of the characters beyond the
255th in a table or query view. However, I want to use code to extract some
of the characters beyond the 255th (e.g. Mid$(strString, 300,5)) and all I
get are strange looking characters.
 
Please disregard prior posts. Breaking up the memo field into separate
fields in a query seems to have solved the problem.
 
Back
Top