Results 1 to 6 of 6
  1. #1
    RegVaz is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2012
    Posts
    4

    Angry Wierd Characters in Field


    i have built a query in Access, which was running fine.
    Suddenly the output in one of the Fields Named description gets populated with wierd characters, any idea why so.

    I have tried removing the field and putting in back in but same result.
    Any help or guidance will be appreciated.

    Thanks

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    Can you post a sample of the weird characters? Perhaps a screen shot of some output.

  3. #3
    RegVaz is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2012
    Posts
    4
    Quote Originally Posted by orange View Post
    Can you post a sample of the weird characters? Perhaps a screen shot of some output.
    Project NameCommon NameEPMO Project IdentifierProject IDDescriptionaaa1234a-1234bbbddd4567b-4567ccc00001021

  4. #4
    RegVaz is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2012
    Posts
    4
    Project NameCommon NameEPMO Project IdentifierProject IDDescriptionaaa1234a-1234bbbddd4567b-4567ccc00001021

  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    It appears you have some unprintable characters in your data.
    Where did the data come from? Have you created forms or reports lately and if so was the data "good"?

    It may be some corruption. Do you have a backup(s) of your database?

  6. #6
    RegVaz is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2012
    Posts
    4
    I managed to solve the problem (If it did exist at all) simply made a copy of the query and opened this copy, all field showed up fine and surprisingly enough when i ran the original version of the query, that was corrected as well.

    thanks again for looking into this.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Limited characters in a memo field
    By Robbyp2001 in forum Forms
    Replies: 11
    Last Post: 11-24-2011, 07:04 AM
  2. Grab first characters from field
    By sau3-access in forum Access
    Replies: 1
    Last Post: 10-04-2011, 10:40 AM
  3. Replies: 9
    Last Post: 09-23-2010, 10:42 AM
  4. MDB database field limited to 64 or 255 characters
    By galapogos in forum Programming
    Replies: 1
    Last Post: 04-06-2010, 10:22 AM
  5. Counting Characters in a text field
    By velvettiger in forum Queries
    Replies: 1
    Last Post: 03-12-2010, 12:36 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums