foxxrunning
Member
- Local time
- Yesterday, 20:14
- Joined
- Oct 6, 2019
- Messages
- 109
Trying to create a report in which I concatenate a First Name and Last Name. Should be textbook simple. This is the code
=[Patients]![Firstname]+" "+[Patients]![LastName]
which I put in the Control Source field for the text box . Tried it with & and +.
What happens is when I change from design view to Report view, instead of seeing the Firstname and Lastname fields together, I get a msgbox asking me for First Name. Why does a msgbox pop up instead of the actual concatenated field???
=[Patients]![Firstname]+" "+[Patients]![LastName]
which I put in the Control Source field for the text box . Tried it with & and +.
What happens is when I change from design view to Report view, instead of seeing the Firstname and Lastname fields together, I get a msgbox asking me for First Name. Why does a msgbox pop up instead of the actual concatenated field???