I believe Replace() will work in code and was left out of queries and other
expressions. You may need to create your own "wrapper" for the function:
Function ReplaceIt(psText as String, psFind as String, psSubs as String) as
String
ReplaceIt=Replace(psText , psFind , psSubs )
End Function
Then, set your control source to
=ReplaceIt([App-PrincipalAddress],Chr(13) & Chr(10)," ")


--
Duane Hookom
MS Access MVP


"KRISH" wrote in message
...
Hi!

I am using Replace() in control source of a TextBox of my
report as

=Replace([App-PrincipalAddress],Chr(13) & Chr(10)," ")

Problem is if i open the report, it is asking a paramater
for Report(). This problem is coming on machine Office
2000. But the same is working fine on Office XP. Kindly
help how to solve the problem on Office 2000. Thanks for
any help

Krish