formatfield

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

Guest

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])))
 
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.
 
Back
Top