Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Find (and remove) Specific Text in a field - for a Report
Sweeet. That looks more efficient than my big ole IIF statement. The only drawback is that is seems to cut off a PERIOD at the end of my text (if there was a period). It is okay in this case, the final period is not crutial data. Can you explain to me the Second Set of "..." in the InStr...- bte
- Post #6
- Forum: Microsoft: Access Reports
-
Find (and remove) Specific Text in a field - for a Report
Hey that worked! Thanks! Unfortunately, not all records have the "..." in that field, so I was getting #ERROR when it did not... So, I combined your code with a big IIF, checked to see if the InStr was returning Pos 0, blah blah, bada-bing - now it all works. Here is my final code...- bte
- Post #3
- Forum: Microsoft: Access Reports
-
Find (and remove) Specific Text in a field - for a Report
I have data coming in a field as text. In some records, there is very specific text "..." and then more word text after it. (the QUOTES "" are not part of the text, just the ...) I want to keep and report the beginning text in the field and I want to cut off the...- bte
- Thread
- Replies: 6
- Forum: Microsoft: Access Reports
