Results 1 to 4 of 4
  1. #1
    Kareem is offline Novice
    Windows Vista Access 2007
    Join Date
    Dec 2009
    Posts
    2

    Permitted certain characters in a table in a Text Field Type [Access 2007]

    Hello!



    What I want is to only allow the letters to be written in a text field type to be either X or Y.
    How can I do so only by changing the field properties?

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    I don't think you can do this via field properties. Though I could be wrong. I know that you can do it easily in the AfterUpdate event using a little VB.

  3. #3
    Kareem is offline Novice
    Windows Vista Access 2007
    Join Date
    Dec 2009
    Posts
    2
    Well, it has to be possible. My friends got it in a computer quiz, and I have to do the same one tomorrow. No one knew how to do it...

  4. #4
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    well check out the Masks - that might be one way....

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

Similar Threads

  1. Importing text file into Access Table
    By Anthony in forum Import/Export Data
    Replies: 13
    Last Post: 09-23-2009, 04:47 PM
  2. Replies: 3
    Last Post: 03-27-2009, 06:50 AM
  3. Replies: 0
    Last Post: 02-27-2009, 01:27 PM
  4. fields of type text
    By ashiers in forum Forms
    Replies: 0
    Last Post: 11-28-2008, 10:52 AM
  5. Replies: 1
    Last Post: 10-09-2008, 04:48 AM

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