Text field valid Characters

Posted on 2012-08-17
Last Modified: 2012-08-20
Is there a list somewhere of valid and invalid characters to use in text field?  I've searched around on the internet and haven't been able to find a comprehensive list.
Question by:dgran
    LVL 12

    Accepted Solution

    This has quite a lot of invalid characters
    LVL 65

    Expert Comment

    by:Jim Horn
    The above comment is correct if you're asking about text field names, or any other control name.

    If you're asking about characters in a text field, then I think all ANSI characters are good, and if you need to go beyond that you'd need a RichTextBox control.
    LVL 13

    Expert Comment

    There are also field names which are invalid as well, and some which can be used, but must have brackets around them.

    You may also want to consider if you're using wildcard searches, then you'll have to escape some characters to search for them. This is with the value , not the field name.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Suggested Solutions

    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now