Text box with multiple fields as the control source.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

Having difficulties creating a report text field that is comprised of
multiple fields. Example of control source: =[RFI No 1] + ", " +[RFI No
2] + "' " +[RFI No 3]. The problem I am having is when the record [RFI No #]
is null the whole text returns as empty. What is the code that will allow
for these null records. Many thanks. Max
 
Max said:
Having difficulties creating a report text field that is comprised of
multiple fields. Example of control source: =[RFI No 1] + ", " +[RFI No
2] + "' " +[RFI No 3]. The problem I am having is when the record [RFI No #]
is null the whole text returns as empty. What is the code that will allow
for these null records. Many thanks. Max
Click to expand...


Use & instead of +
 
Back
Top