how can I Let numeric field = null

[joshs1100]

I am trying to use code to remove a value entered into a numeric field on a form. When I use "Let Fieldname = Null" I get run-time error '3162'. If I use "Let Fieldname = Empty" it puts a '0' in the field.
I want the field to be equal to the same thing it is when you press delete on the field, which it does allow with no error.

Thanks in advance for any help.

 

[Rolliee]

let num = vbnull

 

[Rolliee]

I just checked and vbNull will not work. What did seem to work is to set the [fields(?)) = ""