Gap Before a Name

B

Bob V

Is it possible to have a gap before OwnerLastName , '',
thanks in Advance if you can help..........Bob

Name:
IIf(IsNull([tblOwnerInfo].[OwnerLastName]),'',[tblOwnerInfo].[OwnerLastName]
& ', ') &
IIf(IsNull([tblOwnerInfo].[OwnerFirstName]),'',[tblOwnerInfo].[OwnerFirstName])
 
A

akphidelt

IIf(IsNull([tblOwnerInfo].[OwnerLastName]),'',[tblOwnerInfo].[OwnerLastName]
& ', ') & " " &
IIf(IsNull([tblOwnerInfo].[OwnerFirstName]),'',[tblOwnerInfo].[OwnerFirstName])

Insert " " & from the code above
 
B

Bob V

Sorry I wanted " gap" LastName ",Gap" FirstName
Thanks Bob

akphidelt said:
IIf(IsNull([tblOwnerInfo].[OwnerLastName]),'',[tblOwnerInfo].[OwnerLastName]
& ', ') & " " &
IIf(IsNull([tblOwnerInfo].[OwnerFirstName]),'',[tblOwnerInfo].[OwnerFirstName])

Insert " " & from the code above

Bob V said:
Is it possible to have a gap before OwnerLastName , '',
thanks in Advance if you can help..........Bob

Name:
IIf(IsNull([tblOwnerInfo].[OwnerLastName]),'',[tblOwnerInfo].[OwnerLastName]
& ', ') &
IIf(IsNull([tblOwnerInfo].[OwnerFirstName]),'',[tblOwnerInfo].[OwnerFirstName])
Click to expand...
Click to expand...
 
Top