L
louonline
Hello again,
I have a textbox on a form and at table level the settings for it are
as follows......
Data Type = text
Field Length = 1
Required = YES
Allow Zero length = NO
I assumed that with these settings (when in the form tied to this
table) you MUST enter data into this field (once it gets the focus)
before you can move to the next field.
For some reason I can hit Tab or Enter and no error warning is
generated that this field cannot be left empty/null and can just move
on to the next field.
It appears the Required and Zero Length Properties settings for this
field in the Table are completely ignored!
At form level I have no Events inserted for this field.
I have checked spelling.
Run the DB on three different computers, same result.
Now here is the queer part; if I DO enter a letter (or anything) in
this field and then delete it, the table settings spring into action
and the standard MS message informing me that this field must have
data and cannot be left null is displayed!
Is there any `form event' that can override the settings in the
table?
I am under the impression that settings in the table take precedence
above all else perhaps (most likely) I'm wrong.
I don't want to start playing around with form events if there may be
some other reason for this strange behaviour.
BTW, this is not related to my previous post regarding automatically
clearing a field.
Any help would be appreciated.
Regards,
Lou
I have a textbox on a form and at table level the settings for it are
as follows......
Data Type = text
Field Length = 1
Required = YES
Allow Zero length = NO
I assumed that with these settings (when in the form tied to this
table) you MUST enter data into this field (once it gets the focus)
before you can move to the next field.
For some reason I can hit Tab or Enter and no error warning is
generated that this field cannot be left empty/null and can just move
on to the next field.
It appears the Required and Zero Length Properties settings for this
field in the Table are completely ignored!
At form level I have no Events inserted for this field.
I have checked spelling.
Run the DB on three different computers, same result.
Now here is the queer part; if I DO enter a letter (or anything) in
this field and then delete it, the table settings spring into action
and the standard MS message informing me that this field must have
data and cannot be left null is displayed!
Is there any `form event' that can override the settings in the
table?
I am under the impression that settings in the table take precedence
above all else perhaps (most likely) I'm wrong.
I don't want to start playing around with form events if there may be
some other reason for this strange behaviour.
BTW, this is not related to my previous post regarding automatically
clearing a field.
Any help would be appreciated.
Regards,
Lou