I was wondering if someone has had this problem before:
I have a textbox on a report with the following control source, where SupF and SupL are the supervisor's first and last name respectively:
="Supervisor: " & [SupF] & " " & [SupL]
What is being displayed when the report is run is Supervisor: [SupF], where SupF is an actual name from the query the report is based on, but SupL is being left off. Both fields exist in the query, if I try it the other way around ="Supervisor: " & [SupL] & " " & [SupF] then the last name shows, but not the first name.
Things to consider:
- The width of the textbox is fine. I have even expanded it to the width of the report
- Can Grow/Can Shrink/Hide Duplicates are all set to No, but these shouldn't matter
- I renamed the textbox to txtEmployee_Sup, so no name conflicts should be a problem
- The problem exists when the control source is =[SupF] & [SupL] or the reverse =[SupL] & [SupF] - only one field is being retrieved
If you have any suggestions, please let me know
I have a textbox on a report with the following control source, where SupF and SupL are the supervisor's first and last name respectively:
="Supervisor: " & [SupF] & " " & [SupL]
What is being displayed when the report is run is Supervisor: [SupF], where SupF is an actual name from the query the report is based on, but SupL is being left off. Both fields exist in the query, if I try it the other way around ="Supervisor: " & [SupL] & " " & [SupF] then the last name shows, but not the first name.
Things to consider:
- The width of the textbox is fine. I have even expanded it to the width of the report
- Can Grow/Can Shrink/Hide Duplicates are all set to No, but these shouldn't matter
- I renamed the textbox to txtEmployee_Sup, so no name conflicts should be a problem
- The problem exists when the control source is =[SupF] & [SupL] or the reverse =[SupL] & [SupF] - only one field is being retrieved
If you have any suggestions, please let me know