Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
    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
    Gurus Commemorating The Painting Of Guru Gobind Singh Ji By Bhagat Singh Bedi History of Sikhism Apr 15, 2015

  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]
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page