Previous Thread

6/30/2006 5:05:02 AM    Control Validation
What is the best expression to use in the Validate property for a control to 
 
test that some text (of unconstrained length) has been entered.



6/30/2006 8:54:51 PM    Re: Control Validation
Open the table in design view, and set the field's Required property to Yes. 
 
If you prefer to use the Validation Rule of the field in the table: 
 
Is Not Null 
 
If you want to do it in a form, use the BeforeUpdate event of the form to 
 
test it the control IsNull(). You cannot merely use the Validation Rule of 
 
the control, since that is not triggered if nothing is entered. 
 
-- 
 
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. 
 
"Confused Slug" <ConfusedSlug@discussions.microsoft.com> wrote in message 
 
news:59AAFFB6-4C0E-4DD5-B04B-120ED9547C29@microsoft.com...