Data type mismatch - excel userform to access table

HI, I am using the code below to send data from a excel userform to an access table. I get a data mismatch at the line ".Fields("account_no").Value = textname2" In access this is a number field. If I the user fills in the account number in the user form, the data is submitted correctly. If they leave it blank then they get the data type mismatch. How can I avoid this error. I need the form to be submitted regardless or not if the field is blank.

Thanks in advance.

Please Login or Register  to view this content.

.Update
End With

Yes access will allow a zero, but I rather it not have a zero the field. I do not have validation turned on for that field in access. The field is not a required field and I am not sure how to check if nulls are allowed.

I am still having trouble correcting this this error. It seems like the userform is submiting spaces and when I hover over the compile error . I tried the code below to try to get it to submit as empty, but that didn't work. What else can I do to make sure when the userform data is submitted to access the blank field is really empty? This field is a numeric field, not sure if this makes a different. But if I put a value in the field it works perfectly. But the field in not required and don't want to force the user to enter a value.

Please Login or Register  to view this content.

I found this solution in another post, but this seems like it goes to a spreadsheet first before going to Access. My user form should send the data directly to access.

Please Login or Register  to view this content.

Thanks