Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Memo Fields

Discussion in 'Information Technology' started by tezza, Nov 1, 2005.

Tags:
  1. tezza

    tezza
    Expand Collapse
    Guest

    Hi,
    I have created a table from some data exported from another application.
    One of the fields on my table holds a description greater than 256 chars so
    I have made it a memo field.
    When I use Search by Form on this field I do not always get the correct
    results.
    If I look at the underlying ascii data, lets say in Notepad, I can find what
    I am looking for.
    If I use Search by Form on the memo field in my table, I do not get the same
    results.
    Anybody got any clues?
    The memo field is a concatenation of 15, 55 character descriptions and
    contains lots of space characters.
     
  2. Loading...

    Similar Threads Forum Date
    Sikh Commemoration Today Politics and Administration Jun 5, 2017
    Self Memoirs Of Illusions Blogs Mar 15, 2017
    Opinion Beyond Chamkaur: Wars, Battles & Memories Sikh Sikhi Sikhism Dec 23, 2015
    Memorial To The Remarkable Sikh Soldiers Of WWI Sikh Personalities Oct 31, 2015
    Narayanjot Kaur Aka Spnadmin Some Memories Intellectual Articles Apr 28, 2015

  3. OP
    Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    tezza wrote:
    > Hi,
    > I have created a table from some data exported from another
    > application. One of the fields on my table holds a description
    > greater than 256 chars so I have made it a memo field.
    > When I use Search by Form on this field I do not always get the
    > correct results.
    > If I look at the underlying ascii data, lets say in Notepad, I can
    > find what I am looking for.
    > If I use Search by Form on the memo field in my table, I do not get
    > the same results.
    > Anybody got any clues?
    > The memo field is a concatenation of 15, 55 character descriptions and
    > contains lots of space characters.


    As I recall the search feature only searches the first 255 characters of
    a memo field.

    --
    Joseph Meehan

    Dia duit
     
  4. OP
    Sheila D

    Sheila D
    Expand Collapse
    Guest

    Cn you be a bit more specific, is it ascii characters you are looking for or
    normal text?

    Sheila

    "tezza" wrote:

    > Hi,
    > I have created a table from some data exported from another application.
    > One of the fields on my table holds a description greater than 256 chars so
    > I have made it a memo field.
    > When I use Search by Form on this field I do not always get the correct
    > results.
    > If I look at the underlying ascii data, lets say in Notepad, I can find what
    > I am looking for.
    > If I use Search by Form on the memo field in my table, I do not get the same
    > results.
    > Anybody got any clues?
    > The memo field is a concatenation of 15, 55 character descriptions and
    > contains lots of space characters.
     
  5. OP
    tezza

    tezza
    Expand Collapse
    Guest

    Hi Sheila,
    I'm searching for normal text.
    Sorry if I confused you with the ascii bit.
    The original data was exported as ascii from another application and I have
    imported it into a table.

    "Sheila D" wrote:

    > Cn you be a bit more specific, is it ascii characters you are looking for or
    > normal text?
    >
    > Sheila
    >
    > "tezza" wrote:
    >
    > > Hi,
    > > I have created a table from some data exported from another application.
    > > One of the fields on my table holds a description greater than 256 chars so
    > > I have made it a memo field.
    > > When I use Search by Form on this field I do not always get the correct
    > > results.
    > > If I look at the underlying ascii data, lets say in Notepad, I can find what
    > > I am looking for.
    > > If I use Search by Form on the memo field in my table, I do not get the same
    > > results.
    > > Anybody got any clues?
    > > The memo field is a concatenation of 15, 55 character descriptions and
    > > contains lots of space characters.
     
  6. OP
    John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Mon, 31 Oct 2005 05:11:12 -0800, "tezza"
    <tezza@discussions.microsoft.com> wrote:

    >Hi,
    >I have created a table from some data exported from another application.
    >One of the fields on my table holds a description greater than 256 chars so
    >I have made it a memo field.
    >When I use Search by Form on this field I do not always get the correct
    >results.
    >If I look at the underlying ascii data, lets say in Notepad, I can find what
    >I am looking for.
    >If I use Search by Form on the memo field in my table, I do not get the same
    >results.
    >Anybody got any clues?
    >The memo field is a concatenation of 15, 55 character descriptions and
    >contains lots of space characters.


    If Search by Form fails for you (as Joseph suggests), you can use the
    form's Filter property instead; set the filter to

    [Memofield] LIKE "*the text to search*"

    Is there any way you could import these 15 descriptions into fifteen
    *records* in a related description table? Might make searching easier!

    John W. Vinson[MVP]
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page