[AccessD] Error 3314 (required field) - trap in form_error

Thanks, Dan.

Well, I realise there would be a difference of style or preference here, 
as against a question of right and wrong.  For myself, if I was ending 
up with a ZLS in a memo field, my approach and advice would be to 
address the problem that is causing this, rather than trying to cover 
off the possibility in my validation code.

Similarly, in the scenario originally described by Gale (Required field 
being trapped on a form event), my preference would still be the 
code-free solution of using Validation Rule property.

In fact, I would also normally use Validation Rule rather than code in 
the case of situations such as your:
Not IsNull(A) And IsNull(B)

Regards
Steve


Dan Waters wrote:
> Steve,
> 
> I agree that while the Screen.ActiveControl may be causing the wrong control
> to be checked, the value of the control for memo fields could indeed be a
> zero length string and must be checked for.  In this example all controls
> are being checked (I assumed all the controls on the form could contain
> text), so checking for a ZLS on other controls won't hurt.