[Webinar] Streamline your web hosting managementRegister Today


Validation Rule

Posted on 2006-05-16
Medium Priority
Last Modified: 2008-03-18
I have an Access 2K database running in 2003 and i am having some validation rule problems.

For some reason it doesn't seem to like the wild card character.

if i give it the rule [ALike 'a*'] then it will only accept the characters 'a' and then '*'. rather than accepting 'aa' or 'abc'

What am i doing wrong?

Kind  regards

Question by:dchoxford
LVL 58

Expert Comment

ID: 16691616
Hello dchoxford

Have you tried just this:   Like 'a*'
You do not need the field name in a validation rule for a simple expression like that.


Author Comment

ID: 16691802
Yes i have, the square brackets were to denote the text rather than using quotes that i thought would be confusing in the instance.

It works under 2K but not as a 2K file opened in 2003

LVL 61

Accepted Solution

mbizup earned 1000 total points
ID: 16691891
This is a long shot...
Check under tools -> options under the Tables/queries  tab.  If The checkbox under SQL server compatible syntax (ANSI 92) is checked, I think the  %  wildcard would be recognized instead of  *.
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

LVL 15

Expert Comment

ID: 16692511
Could also try a forced concatenation like this:

Like 'a' & '*'

Author Comment

ID: 16697680
thanks mbizup,

Because i'm using the .ade A2003 seems to be using the SQL server compatible syntax which isn't the case for the users still on A2K. I'll just take off validation rules until all the clients are on the same version.
LVL 61

Expert Comment

ID: 16698028
Glad I could help.

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
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 …
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

607 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