Checking a value has been entered

[Always_Learning]

Hi There,

I have a form with a number of entry fields and after a button is clicked I write to an MS Sql datatable. Everything works fine as long as I put a value in each field. If I do not put a value in one of the fields the sql does not run and the record is not added / updated in the database.
I have tried checking the length of the data in the field using
Ent_Length = Len(tb_TagDesc)
or
Ent_Length = Len(tb_TagDesc.Text)
or
Ent_Length = Len(tb_TagDesc.value) but nothing shows.

I am using Access 2007, 32 bit Windows 7

Any help you can give would be appreciated.

Best Regards,

 

[JHB]

Use IsNull:

If IsNull(tb_TagDesc) Then
  Msgbox "Not finish"
[I]  ...[/I]