Assign empty string to numeric variable

[Stevenn]

I have a form in which I assign some values

With Me
    Let lBudgetID = .txtBudgetID.Value
    Let lMonthNo = .txtMonth.Value
End With

but if the fields txtBudgetID and txtMonth are empty, the code will fail since it's not possible to convert empty strings to numeric variables.

How can I make sure the code will work?

 

[RoryA]

You could use Val which will return 0 for an empty string, or you could simply verify the values:

With Me
    lBudgetID = IIf(.txtBudgetID.Value = "", 0, .txtBudgetID.Value)
    lMonthNo = IIf(.txtMonth.Value = "", 0, .txtMonth.Value
End With