The test only works if something causes the control to detect a change.
Simply entering the control and leaving it will not cause the control to
detect a change in its text value.
If you enter one character into the control and then delete the character the
control will detect the change and will check the validation rule.
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
John134 wrote:
> Thanks for the reply, Allen. The Like expression worked but the IsNull
> didn't. I tried Not Is Null and that didn't prevent the field from being
> skipped over either. The same with putting the rule on the control property.
>
> I tried putting Not IsNull(fieldname) in the table properties and had no
> luck there either.
>
> Any suggestions appreciated.
>
> John134
> "Allen Browne" wrote:
>
>> Try a validation rule of:
>> Is Null OR Like "#*[a-z]*"
>>
>> More info and examples of validation rules:
>> http://allenbrowne.com/ValidationRule.html
>>
>> --
>> Allen Browne - Microsoft MVP. Perth, Western Australia
>> Tips for Access users - http://allenbrowne.com/tips.html
>> Reply to group, rather than allenbrowne at mvps dot org.
>>
>> "John134" <(E-Mail Removed)> wrote in message
>> news:46CF9DCF-D76E-427D-9191-(E-Mail Removed)...
>>> Is it possible to provide an input mask or a validation rule so that the
>>> entry must have at least one alpha character? Any number of characters is
>>> acceptable.
>>>
>>> And, would it also be possible that it start with a digit?
>>>
>>> John134
>>
Similar Threads
Linear Mode
