formatfield

[Dan @BCBS]

I don't understand what is wrong, I'm just trying to merge tow values (adrln1
and adrln2) into a textbox on a report! When I run it I get a message to
Enter parameter Value "formatfield"

Does anyone see something worng with this code

=IIf([adrln2] Is Null,formatfield([adrln1]),Trim(formatfield([adrln1]) & ",
" & formatfield([adrln2])))

 

[Jerry Whittle]

I don't see a formatfield field function built into Access. Is it a
user-defined function or sub?

Try removing formatfield( ) and see what that returns.