Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2016
    Posts
    13

    Input " Like A* " in Validation Rule Property but it shows " ALike 'A*' "

    Hello,

    I have a problem that when I entered Like A* in a validation rule of an AgentID field,


    (The purpose is to force the field to use A as the first character.)
    the rule, however, showed ALike 'A*'. So I tried to enter the rule like this in my other access
    database files and got the same result.

    How to get rid of A in ALike 'A*'?
    Please give me the answer.
    Thank you.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Alike is a legal word for A*.
    what did you want?

  3. #3
    Join Date
    Apr 2016
    Posts
    13
    Hi ranman,
    The problem is when I add a record in the field, it didn't pass the validation rule even if I typed A as the first letter.

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    If the rule is on the form and it ignores the rule, then theres not much to do.
    It should be enforcing it.

  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Show us the problem code with associated data. Or post the database and some sample data. (zip file)

  6. #6
    Join Date
    Apr 2016
    Posts
    13
    The file has a table named "Agents" and a module named "Module1" that is the codes for creating the table.
    Chap12.zip

  7. #7
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397

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

Similar Threads

  1. Replies: 1
    Last Post: 09-07-2015, 08:00 AM
  2. Replies: 4
    Last Post: 01-22-2015, 10:30 AM
  3. Replies: 1
    Last Post: 09-03-2014, 03:27 AM
  4. Replies: 11
    Last Post: 03-29-2012, 02:32 PM
  5. Replies: 1
    Last Post: 08-02-2011, 07:21 AM

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