form field not allowing to exit without entering data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

My form has 3 bound fields, 2 text boxes for data entry and a list box to
make a selection. For the last week i've been playing around with different
code snippets trying to learn a bit about what you all do. I had some code
that did not allow the user to go to another field without entering some
data. I've removed that code and the only code left is on the on exit to
change all text to capitals.

when I open the form i can click on either of the text fields and go back
and forth, but if i choose an item from the listbox then go to a text field i
can't exit it until i enter data.

why might this be?

TDR
 
Hi,



Since the control is bound to a field, I imagine the field does NOT
allow NULL data, so, requires you fill something in its associated control.
Definitively, if the field does not allow NULL, the record could not be
saved as long as nothing is supplied for that field.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top