ms access #TYPE! error on report when no data
Posted on 2016-08-26
I have an MS access report. Run perfect when where is data. If there is NO data I get a #Type! error on a particular field
In the report itself, under the detail section I have a text box that contains a TRIM statement: =Trim([PRIMARY_NAME]) & " " & Trim([Label_NAME])
If there is no data on the report, I get #Type! error showing on the report when I run the print preview.
I tried to modify the trim statement to be : =IIf(IsNull([PRIMARY_NAME])," ",Trim([PRIMARY_NAME]) & " " & Trim([Label_NAME])) but that did not work.
I wrote it so if the PRIMARY_NAME field was null then it would just output a blank space. This was probably wrong because there is 2 fields in my trim statement.
I am probably missing something simple.... can someone give advice how to get rid of that #Type! error? Thank you.