Results 1 to 5 of 5
  1. #1
    Accession is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Posts
    7

    Restricting Access Form Textbox to Text only.


    Hello everyone, I have a form setup to populate a field in a table.
    However, I need to add some VBA that prohibits the user from entering symbols, example: !@#$%, the textbox should only allow text, space and the back key.

    Any help will be greatly appreciated.

    AC

  2. #2
    Dan is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2011
    Posts
    15

  3. #3
    Accession is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Posts
    7
    Is this suppose to be funny? Can't believe you took the time to be an !@#$%.

  4. #4
    nicknameoscar is offline Advanced Beginner
    Windows XP Access 2000
    Join Date
    Apr 2011
    Location
    Earlysville, VA
    Posts
    91
    Did you let that animation finish? It goes to valid Google search results and the first hit seems to answer your question. It is not using VBA code but validation rules instead.

  5. #5
    Dan is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2011
    Posts
    15
    Quote Originally Posted by Accession View Post
    Is this suppose to be funny? Can't believe you took the time to be an !@#$%.
    The validation rule property is in the property sheet for the text box. Always try google first.

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

Similar Threads

  1. Replies: 4
    Last Post: 06-29-2011, 06:32 AM
  2. Replies: 2
    Last Post: 11-16-2010, 10:55 AM
  3. access restricting users
    By jmskms in forum Access
    Replies: 2
    Last Post: 03-05-2010, 08:39 AM
  4. Replies: 3
    Last Post: 03-28-2009, 06:06 PM
  5. Replies: 0
    Last Post: 03-26-2008, 08:46 PM

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