[dba-SQLServer] Validation rules and SQL Server

Arthur Fuller fuller.artful at gmail.com
Mon Apr 14 07:59:30 CDT 2014


David,

I haven't seen this, but my first guess would be to check whether there's a
default value either on the control or in the SQL column. Failing that,
maybe you could investigate further by adding a MsgBox call on the
control's AfterUpdate event, and see what the value actually is after you
blank the control.

Arthur


On Sun, Apr 13, 2014 at 6:08 PM, David Emerson <newsgrps at dalyn.co.nz> wrote:

> Listers,
>
> I have a 2010 database accdb file which uses DSNless connections to get
> recordsets for form and control sources.  It have a control which is linked
> to tinyint field in an SQL 2008 table.  I have a validation rule in the
> control "Is Not Null" and a Validation Text.  However if I clear out the
> value in the field the validation rule doesn't fire.
>
> I have previously used adp's with SQL back ends and have not had this
> problem.  Has anyone come across this before?
>
>


More information about the dba-SQLServer mailing list