NZ function A 2013

[Dick7Access]

I can't find my notes from last time someone here instructed me on the NZ function. Sorry I have to ask again. This function works well as long as everybody has a first name. However, doesn't when first name is null.

I tried this code but it's not correct.

strCombN = Nz(Me.txtNameF) & (" and " + Me.txtSpouce)    'combines husband and wife first name over picture

Function CombFandS()

Dim strCombN As String

                  
If IsNull(txtNameL) Then
  MsgBox "You have already reached the Last person.", vbApplicationModal, "Remember God does Knee Mail"
Else
 strCombN = Me.txtNameF & (" and " + Me.txtSpouce)    'combines husband and wife first name over picture
 combName = strCombN
 
 End If
 End Function

 

[Rx_]

and " + Me.txtSpouce
and " & Me.txtspouce ' spouse ?
The + can error with a string. for example 6 + null = null "hi" + null = null 6 & Null = 6 "hi" & Null = Hi

I have to catch the train, try that out.

 

[rzw0wr]

srtComboN = Nz(Me.txtNameF,"") & " And " & nz(Me.txtSpouse,"")

Dale

 

[Dick7Access]

srtComboN = Nz(Me.txtNameF,"") & " And " & nz(Me.txtSpouse,"")

Dale

Thanks! Just like down town! works great.
This is what I ended up with.

strCombN = Nz(Me.txtNameF, "") & (" and " + Me.txtSpouce) 'combines husband and wife first name over picture

 

[rzw0wr]

whatever works for you.

The + can error with a string

Dale