Null Values

[Mark Stone]

I have set the table column setting to not allow Null but
the form which is bound to this is allowing me to move to
the next record or even close the form without inputting
data into the text boxes.

How can I stop this from happening?

Thanks for your time.

 

[Andi Mayer]

I have set the table column setting to not allow Null but
the form which is bound to this is allowing me to move to
the next record or even close the form without inputting
data into the text boxes.

How can I stop this from happening?

Thanks for your time.

use the beforeUpdate event:

if isnull(Me.myTxtBox) then
Cancel=true
msgbox "Need Input"
endif

 

[Van T. Dinh]

Check also the AllowZeroLength Property of the Field in your Table.

Check Access Help topic "Required Property" and read carefully how the
Required Property and the AllowZeroLength Property work together.

 

[LEECATES]

I have set the table column setting to not allow Null but
the form which is bound to this is allowing me to move to
the next record or even close the form without inputting
data into the text boxes.

How can I stop this from happening?

Thanks for your time.