I have the following expression in a text box on a report (for contacts). Not all contacts have a middle name, suffix or title.

=[title]+" "+[first_name]+" "+[middle_name]+" "+[last_name]+" "+[suffix]

Some of those contacts' names do not show on the report while some do.

i.e. Mr. Joe Smith (no middle name or suffix) shows fine on the report. On another, Mr. Joe Schmoe, it will not show a name at all. If I change the expression to just include the Title, first and last names, it appears just fine. However, then the entire report omits the middle name and suffix for every contact.

Can anyone tell me why this is happening? And possibly how to correct or work around it?

Thanks,
Nick

You are dealing with null values and Access can't (or just won't) append nulls in an expression. Therefore, you have to use the NZ function. Look it up in online help.

Regards,

Beth M

I'll give it a shot.

Thanks!