Access report #Error in text field
Posted on 2014-03-12
system; win7pro, access 2010 split database. Note that this works fine in Win XP.
A text field on the report shows #Error in his field after being populated. All other fields populate properly. This is an unbound field that is populated from a function in a query. The query part is "removecrlf(Jobs.notes) as NotesClear" The report form field is populated with "NotesClear"
the function "removecrlf(Jobs.notes)" is a triple replace function:
replace(replace(replace(data,"i",""), chr(13), ""), chr(10), " ")