<div>
Hello dchoxford<br />
<br />
Have you tried just this: &nbsp; Like 'a*'<br />
You do not need the field name in a validation rule for a simple expression like that.<br />
<br />
(°v°)
</div>


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.

(°v°)

<div>
Yes i have, the square brackets were to denote the text rather than using quotes that i thought would be confusing in the instance.<br />
<br />
It works under 2K but not as a 2K file opened in 2003<br />
<br />

</div>


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



<div>
Could also try a forced concatenation like this:<br />
<br />
Like 'a' &amp;&nbsp;'*'
</div>


Could also try a forced concatenation like this:

Like 'a' & '*'

<div>
thanks mbizup, <br />
<br />
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.<br />

</div>


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.


<div>
<div class="content wysiwyg-content">
I have an Access 2K database running in 2003 and i am having some validation rule problems.<br />
<br />
For some reason it doesn't seem to like the wild card character. <br />
<br />
if i give it the rule [ALike 'a*'] then it will only accept the characters 'a' and then '*'. rather than accepting 'aa' or 'abc'<br />
<br />
What am i doing wrong?<br />
<br />
Kind &nbsp;regards<br />
<br />
DCHOxford<br />

</div>
</div>


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

DCHOxford


Validation Rule

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.