I am trying to combine the city, state and zip in a field for my report and I continually find Access is temperamental. Sometimes it works other times not, but more often than not the latter. I get "error" in the field when looking at it from the view window. Although this doesn't give you the whole picture, here is the expression I use in the Control Source property box: =Trim([AgencyCity] & ", " & [AgencyStateOrProvince] & " " & [AgencyPostalCode])
How can I get this to work correctly and consistently?
How can I get this to work correctly and consistently?