Recent content by Palmer

Thanks, I used... Public Function ReplaceSpace(StrRemoveSpace As String) Let ReplaceSpace = Replace(StrRemoveSpace, "<li>", "", 1, -1, 1) End Function Is there a way to put in a line break or some type of return?

Hi, One of my fields has <li> in the data. I need the <li> to be there for posting to the web, but... I also need to make an Access report using this data minus the <li>. How do I strip it out for reporting purposes, Do I use an If statement and "if so" how do I write it... Actually After...

Hi, I have a report (report A) driven by a query (Query A). I want to copy the report because of the formatting. So now I have report b that needs to be driven by Query B. Is there a way to change all of the fieldnames in the report using a find and replace? Ex. querya.field1 needs to be...

Case statements? Hi, Thanks for the reply. What is the proper syntax for a case statement? Thanks, Matt

Switch? Thanks for the quick reply. I was trying something similar to what you posted, but I was and am getting errors. (I got it to work now. Thanks.) You mentioned using a switch. Could you give me an example? Thanks again, Matt

Hi, I am trying to use an iif statement in my report. I have a field [field1] and it is has four data points 1,2,3,4 I want to say when [field1]=1,"Statement1" and when [field1]=2,"Statement2" and when [field1]=3,"Statement3" and when [field1]=4,"Statement4" Any help on this would be...