Slim Shamble
Registered User.
- Local time
- Today, 22:47
- Joined
- Jun 3, 2016
- Messages
- 29
Hi
I have 3 textboxs for first name, middle name and last name. And I want to display the names entered in this textbox. I try using this code below but its shows only the first and the last name.
Full name: IIF(IsNull([First Name],IIF([First Name]),[First Name]), IIF(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name]))
But this code only display just the first and last name. How do I get it to work also for middle name. That is to display First, Middle and Last Name.
I have 3 textboxs for first name, middle name and last name. And I want to display the names entered in this textbox. I try using this code below but its shows only the first and the last name.
Full name: IIF(IsNull([First Name],IIF([First Name]),[First Name]), IIF(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name]))
But this code only display just the first and last name. How do I get it to work also for middle name. That is to display First, Middle and Last Name.