Null Value/Allow Zero Length Issue

  • Thread starter Thread starter Lori
  • Start date Start date
L

Lori

Hello,
I have a form (Invoices) with a subform (InvDetails) where the subform
displays in datasheet view. Each line in the subform begins with an
activity field that is a combo box. The field is bound by a numeric column,
which is hidden, and displays the second column, which is text.
The problem I have is that my users tend to start a line, delete the value
they entered in this field, and then attempt to leave it. When they do,
they get the error
"You tried to assign the Null calue to a variable that is not a Variant data
type.
What kind of fix can I put in here? Since the value is a number, I can't
set it to allow zero length. I really need that row to be deleted when this
happens. I have not been able to find an event that supercedes the default
error from Access.

I am looking for any suggestions to work around this problem, but I am very
new to using VB code.
Thank you for your help,
Lori
 
Try validating the data entry in the BeforeUpdate Event of
the SubForm.

You can also use the Undo method to cancel the data entry.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top