How to condition a concatenated formula when a field is null

[tcbc]

If the middle initial is null the formula brings back empty field. How do I condition formula below to pull even if Middle initial is blank

formula ={master_cred.first_name} +" "+{master_cred.middle_name}+ " "+ {master_cred.last_name}+","+ " "+{master_cred.degree_type}

 

[Turkbear]

Hi,
Test for the NULL (and/or blanks)first then build the concatenated string:

(If IsNull({master_cred.middle_name}) 
or 
Trim({master_cred.middle_name}) = "" )[COLOR=green]//optional test for blanks instead of true NULLs[/color]
Then
formula ={master_cred.first_name} +" "+{master_cred.last_name}+","+ " "+{master_cred.degree_type}
Else
formula ={master_cred.first_name} +" "+{master_cred.middle_name}+ " "+ {master_cred.last_name}+","+ " "+{master_cred.degree_type}

To Paraphrase:"The Help you get is proportional to the Help you give.."