Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-24-2016, 02:48 AM   #1
AccessPractice
Newly Registered User
 
Join Date: Jun 2016
Posts: 25
Thanks: 11
Thanked 2 Times in 2 Posts
AccessPractice is on a distinguished road
Input " Like A* " in Validation Rule Property but it shows " ALike "A*" "

Hello
I've a problem that when I entered Like A* in the 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*". And when I added a record in the field, it didn't pass the validation rule even if I typed A as the first letter.
In addition, I have 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*" and pass the rule?
Thank you.

AccessPractice is offline   Reply With Quote
The Following User Says Thank You to AccessPractice For This Useful Post:
hassanogaibi (06-28-2016)
Old 06-24-2016, 04:07 AM   #2
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,330
Thanks: 40
Thanked 3,669 Times in 3,537 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
Re: Input " Like A* " in Validation Rule Property but it shows " ALike "A*" "

looking at the sample provided in your identical post here
http://www.accessforums.net/showthread.php?t=60432

you have set your db to use ANSI92 which uses Alike instead of Like.

And if you are using ANSI92 you use % rather than *

For the future, please advise when you are double posting so responders do not waste their time providing the same solutions - see this link for the reasons why

http://www.excelguru.ca/content.php?184
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
The Following User Says Thank You to CJ_London For This Useful Post:
hassanogaibi (06-28-2016)
Old 06-24-2016, 05:37 AM   #3
AccessPractice
Newly Registered User
 
Join Date: Jun 2016
Posts: 25
Thanks: 11
Thanked 2 Times in 2 Posts
AccessPractice is on a distinguished road
Re: Input " Like A* " in Validation Rule Property but it shows " ALike "A*" "

Thank you very much CJ_London and sorry for double posting!

AccessPractice is offline   Reply With Quote
The Following User Says Thank You to AccessPractice For This Useful Post:
hassanogaibi (06-28-2016)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
If "TableA.FieldA" exists in "TableB.FieldB" then return "1" else "2" shdale Queries 8 10-29-2014 05:20 AM
Expr1: Format("012P","0000") Why I get "0001" amolin General 4 10-10-2012 08:33 PM
Query to Convert "Name" field to "Last Name" "First Name" "Middle Name"? derekbeck Queries 5 03-26-2012 03:23 PM
if "1" is typed it shows "!" and vice versa Happy YN Forms 6 04-27-2009 11:23 PM
DropDown shows "X", but records "Y" in other field. brunces General 3 09-14-2004 07:42 AM




All times are GMT -8. The time now is 01:29 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World