Passing null values to variables

[4321z]

I'm trying to pass values from fields within a form to a function shown below;

Function AllDataEnteredForTrade(blTradeSelected As Boolean, stTradePerson As String, dtWkStartDate As Date, intNumDays As Integer) As String
If blTradeSelected = True And Len(stTradePerson) > 0 And stTradePerson <> "None" Then
AllDataEnteredForTrade = "AllEntered"
End If
End Function

But when a field has a null value it can't be passed to the appropriate function variable, is there anyway around this?

 

[KenReay]

Hi

Either make the parameter optional (in the function), or use NZ() to pass a default value

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK