Simple passing into function question

[Ruegen]

I have a function (to string) that pulls in two controls from a form.

These are combo boxes and it pulls in the ID field as int (not long as it's never going to be over 300)

I have Public Function SearchArea(year As Integer, Area As Integer) As String

however if the control is null I don't want the function to react however it doesn't like null and I get an error.

In general how should I handle this if it is null.

Should I when using the function say

strWhere = searcharea(nz(me.cboYear,0),nz(me.cboyear,0)) ?

however this would give me a numeric 0 to have to deal with in the function

is there a way around?

[pbaldy]

If you change Integer to Variant the parameters will take a Null, which can test for in your function.

[Ruegen]

If you change Integer to Variant the parameters will take a Null, which can test for in your function.

That works, but is that the preferred method?

[pbaldy]

Generally I would prefer to handle the Null in the function rather than have to remember to account for it everywhere I may call that function.