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
    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
    Gurus Commemorating The Painting Of Guru Gobind Singh Ji By Bhagat Singh Bedi History of Sikhism Apr 15, 2015
    UK UK Sikh Biker Group ‘Humbled’ to be on Lee Rigby Memorial Ride to Woolwich Barracks in Ilford Breaking News May 24, 2014

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

Share This Page