Results 1 to 9 of 9
  1. #1
    Join Date
    May 2003
    Posts
    11

    Thumbs up Unanswered: memo field problem

    hi,
    Why doenst memo field store and retrieve a single character as against any text with length greater than 1 does not give any problem.

    Any suggesstions?
    thanks,
    hsm

  2. #2
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    If you are trying to find a single character that has no preceding or post charactrs you can use:
    like "d" to find the standalone character d
    but you will not find alll words with the letter d in them
    if you searched as:
    like "d*" you will return words such as dale, day , dare
    one character searches can only occurr with standalone characters in a memo field type
    Same applies for a text field

    HTH
    Reply if you need more assistance

  3. #3
    Join Date
    May 2003
    Posts
    11

    Thumbs up

    no no, my question is ,
    when i enter a 'Single' character' in the memo field and store it, it is lost. But anything of lenth greater than '1' character is saved and retrieved.

    I wanst trying to find occurance of a single character in the field.
    Hope the problem is clear now. Any answers?
    Thanks,
    Hsm

  4. #4
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    That sounds strange...
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

  5. #5
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    I am sorry I was concentrating on the "retrieve" part of your question, not the "store"

    The sample I gave shows that you should be able to store a single character because it retrieved a single character so I agree this is strange.

    Attach the table (structure only) and I will test.

  6. #6
    Join Date
    May 2003
    Posts
    11
    Thanks,
    Ive attached the structure below for your testing. This is one of the many tables in the database.
    Regards,
    hsm
    Attached Files Attached Files

  7. #7
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    Well I created a table with the exact structure you provided and had no trouble inserting single characters in all 5 of the memo fields

    Are you receiving any message when trying to update or insert data into the memo fields?

    What metod are you using
    are you trying to do these updates to straight into the table or from a form that may be using joined tables in the recordsource behind the form.

    Can you insert more than one character using the same procedure?

    Version of Access

  8. #8
    Join Date
    May 2003
    Posts
    11
    no error thrown on insertion.

    yes , i use the same proc to insert 1 / more characters in the field. is there any funda for string conversion or so. it just doenst work.
    Thanks,
    hsm

  9. #9
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    Make sure the staus bar in Access is turned on and when you insert the character from the form - read the status bar.

    If it says that the record is not updatable or something of that nature , and this is a standalone table (no joined tables behind the recordset) then I would be surprised - maybe baffled.

    Do you get an error message?
    does two character insetions work?

    Exactly what is the code to insert?

    Is the data type of the field memo or text?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •