Number fields and Text boxes

[rookery]

I know this is probably quite a trivial question but why am I getting a Data Type Conversion error when I try and save nothing ("&quot into a Number field in a table.

The field size is Long Integer and Format is General Number. I've also set Required to "No". The Format of the text box is set to General Number.

I can see that it doesn't recognise the "" but even if I use the Nz function it doesnt seem to work.

e.g. With MyRs
.AddNew
!adNumeric = Nz(Me.txtAdNumeric)
.Update
End With

Any ideas?

 

[KenReay]

Hi

To begin, NZ() requires two parameters eg Nz(Me.txtAdNumeric,"&quot.

Have you tried:

!adNumeric = Null




Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[rookery]

Thanks Ken. Firstly the second argument is optional and secondly I cant set a field to to Null if there's a chance there may be something in the text box.

I've decided to use the trusty:

If Not Me.txtAdNumeric = "" then
'do something
End if

Crude but effective. Cheers.