Re-curring FRUSTRATING issue

[jgelpi16]

I have a subform that populates a text box on my main form. However, that subform could have no value (when you open the form it is completely blank, don't really know how to explain it). I thought I had the code to solve the problem, but I have just encountered the issue again. Any help will be GREATLY appreciated.

    If Len(Form_SfrmARsAge.txtAgePercent.Value & vbNullString) = 0 Then
        varAging = 0
    Else
        varAging = Form_SfrmARsAge.txtAgePercent.Value
    End If

I keep getting the error message "You entered an expression that has no value.".

[Rawb]

Try using the IsNumeric() Function instead. If it returns False, then set varAging to 0, otherwise set it to the value of Form_SfrmARsAge.txtAgePercent like so.

    If IsNumeric(Form_SfrmARsAge.txtAgePercent.Value) = False Then
        varAging = 0
    Else
        varAging = Form_SfrmARsAge.txtAgePercent.Value
    End If

I ran into a similar problem before and, after posting here, found out that the IsNumeric() Function will quietly "fail" to False if a (numeric) Field doesn't exist. If you use some of the other Functions, they can sometimes throw unexpected errors.

[NoellaG]

Hi,

how about using the good old Nz function?

varAging = Nz(Forms("Form_SfrmArsAge").txtAgepercent,0)

grNG