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?


"Jim Pockmire" <(E-Mail Removed)> wrote in message
news:_g8Qd.58347$(E-Mail Removed)...
> 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.
>
>

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.

"Jim Pockmire" wrote:

> 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.
>
>
>

there's an interesting discussion going on about this topic. Go find it a few
days back in this group.

"Jim Pockmire" wrote:

> 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.
>
>
>

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.


"Rick B" <Anonymous> wrote in message
news:(E-Mail Removed)...
> Not sure what you mean. Memo fields can contain more than 255 characters,
> and you can "access" them. What problem are you encountering?
>
>
> "Jim Pockmire" <(E-Mail Removed)> wrote in message
> news:_g8Qd.58347$(E-Mail Removed)...
>> 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.
>>
>>
>
>

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.


"Jim Pockmire" <(E-Mail Removed)> wrote in message
news:PklQd.63066$(E-Mail Removed)...
>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.
>
>
> "Rick B" <Anonymous> wrote in message
> news:(E-Mail Removed)...
>> Not sure what you mean. Memo fields can contain more than 255
>> characters,
>> and you can "access" them. What problem are you encountering?
>>
>>
>> "Jim Pockmire" <(E-Mail Removed)> wrote in message
>> news:_g8Qd.58347$(E-Mail Removed)...
>>> 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.
>>>
>>>
>>
>>
>
>

Please disregard prior posts. Breaking up the memo field into separate
fields in a query seems to have solved the problem.

"Jim Pockmire" <(E-Mail Removed)> wrote in message
news:8_lQd.61783$(E-Mail Removed)...
> 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.
>
>
> "Jim Pockmire" <(E-Mail Removed)> wrote in message
> news:PklQd.63066$(E-Mail Removed)...
>>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.
>>
>>
>> "Rick B" <Anonymous> wrote in message
>> news:(E-Mail Removed)...
>>> Not sure what you mean. Memo fields can contain more than 255
>>> characters,
>>> and you can "access" them. What problem are you encountering?
>>>
>>>
>>> "Jim Pockmire" <(E-Mail Removed)> wrote in message
>>> news:_g8Qd.58347$(E-Mail Removed)...
>>>> 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.
>>>>
>>>>
>>>
>>>
>>
>>
>
>