<div>
data &nbsp;is a variable in the function call which is driven by a access table field named notes which is a memo field.<br />
<br />
I just noticed a possibility, the control/text box name is the same as the record source &quot;NotesClear&quot;. perhaps you could try that and see if its still ok. tks
</div>


<div>
I don't have the database set up etc but suggest testing a 3-line function first, without embedding in sql. Alternatively, change your sql 'as' part.
</div>


<div>
Tks. I'm going to the client tomorrow or Friday to try just that. I can't duplicate the problem on my systems either.
</div>


<div>
Scott:<br />
<br />
This is a program that I am maintaining, not my development.<br />
<br />
I'm wrestling with the issue that this works fine on XP systems, just an issue with Win7pro sytems, all using the same access version.
</div>


<div>
update:<br />
the whole process is create a hidden access report and convert it to pdf with ms add in. I have been looking at the pdf report and reporting above.<br />
<br />
have removed the pdf conversion and dropped the hidden from the report. Now I'm looking at the report, same thing happens (if comments field empty, report field #Error) but the replace function mentioned above isn't used.<br />
HTH
</div>


<div>
maybe formatting property of field?<br />
also, use NZ to handle nulls in query.
</div>


<div>
coachman how would I do that?
</div>


<div>
if you run the query by itself do you see errors?<br />
if you use 'NZ(data,'')' instead of 'data' in the replace part does this fix it ? (I am assuming 'data' is the field you wish to manipulate)<br />
* note the '' to the right of 'data,' is two single quotes, not one double.
</div>


<div>
excellent response, unfortunately issue not resolved yet. back to the drawing board.
</div>


<div>
<div class="content wysiwyg-content">
system; win7pro, access 2010 split database. Note that this works fine in Win XP.<br />
<br />
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 &quot;removecrlf(Jobs.notes) as NotesClear&quot; The report form field is populated with &quot;NotesClear&quot;<br />
<br />
the function &quot;removecrlf(Jobs.notes)&quot; is a triple replace function:<br />
replace(replace(replace(da<wbr />ta,&quot;i&quot;,&quot;&quot;)<wbr />, chr(13), &quot;&quot;), chr(10), &quot;&nbsp;&quot;)
</div>
</div>


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), " ")

Access report #Error in text field

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.