Comboboxes and validation rules

Tech-Archive recommends: Fix windows errors by optimizing your registry

I have a combo box control in a form and in controls I have set the
validation rule to "is not null" however, the user can pass through the combo
box, leaving the conbo blank. It is as if the validation rule is not applied.

Is there a way to correct this so that when a used enters into a combobox
they can not exit until a value is entered? Wither with code or modifying the
validation rules.

Rgs
M Gordon
.

Relevant Pages

  • Re: Validation rule for email field
    ... table field's validation rule. ... was my shorthand for you using a form and a control. ... "Jeff Boyce" wrote: ... but I have checked the Expression Builder ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Why doesnt "not is null" work for validation on forms?
    ... If the control starts null and remains null, that control's validation rule ... >> trigger the error. ... >> Dev wrote: ...
    (microsoft.public.access.forms)
  • Re: Moving cursor to field on error
    ... if you are changing recordsets and the validation rule is at the ... control level, the new recordset may not meet that rule or the new ... the command button's sub. ... Cancel = True ...
    (microsoft.public.access.formscoding)
  • Re: Moving cursor to field on error
    ... if you are changing recordsets and the validation rule is at the ... control level, the new recordset may not meet that rule or the new recordset ... the command button's sub. ... Cancel = True ...
    (microsoft.public.access.formscoding)
  • Re: Validation Rules
    ... "Tony Williams" wrote in message ... > Validation Property of the control but it doesn't work. ... A validation rule for a control on a form is only enforced if the user actually ...
    (microsoft.public.access.forms)