Return to Answer

Added a set of parentheses

Source Link

edited Jun 7, 2012 at 20:43

5.8k
2
19
29

Combine your updated code with what Devdatta provided:

Function FindLabel ( [HSE_NO], [FRAC_NO] )
  if (IsNull[FRAC_NO]IsNull([FRAC_NO])) then
    FindLabel = [HSE_NO]
  else
    FindLabel = [HSE_NO] & vbNewLine & [FRAC_NO] 
  End If
End Function

Combine your updated code with what Devdatta provided:

Function FindLabel ( [HSE_NO], [FRAC_NO] )
  if (IsNull[FRAC_NO]) then
    FindLabel = [HSE_NO]
  else
    FindLabel = [HSE_NO] & vbNewLine & [FRAC_NO] 
  End If
End Function

Combine your updated code with what Devdatta provided:

Function FindLabel ( [HSE_NO], [FRAC_NO] )
  if (IsNull([FRAC_NO])) then
    FindLabel = [HSE_NO]
  else
    FindLabel = [HSE_NO] & vbNewLine & [FRAC_NO] 
  End If
End Function

Source Link

created Jun 7, 2012 at 20:35

kenbuja

5.8k
2
19
29

Combine your updated code with what Devdatta provided:

Function FindLabel ( [HSE_NO], [FRAC_NO] )
  if (IsNull[FRAC_NO]) then
    FindLabel = [HSE_NO]
  else
    FindLabel = [HSE_NO] & vbNewLine & [FRAC_NO] 
  End If
End Function