Text Box Code Question, Might Stump Ya!!!

[johnnycoco]

Alright, I recently converted my access97 database file into an access2000 file. In the process some of the reports did not make it into 2000 format. Therefore, I am recreating them in access2000. I have hit a snag in one of them however.

The control source for my text box is "RespDuties" which is in HTML format, read from the web and diddled with SQL to get it into the report. Previously in 97 the text box contained the line:

IIf(Len([RespDuties])>0,RemoveBreaks([RespDuties]),"&quot

This line checks to see if the source is actually there, and if so removes the <BR> tags and formats the output on the report so that the <BR>'s get replaced with newlines on the output. RemoveBreaks is a function within the ASP on the client side.
Any ideas?

 

[MichaelRed]

only in the lack of a specifc question


MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over