gessie Posted October 26, 2007 Share Posted October 26, 2007 Hi Just got back to an FMP database that someone was looking after inputting data while I was away for a while. They have left their new additions in red formatted text to highlight them. Now I can go and check their inputs and decide whether to keep them. In case I miss some though - I was wondering if it's possible to search all fields for anything formatted in red. Any ideas how I might try that? thanx gessie Link to comment Share on other sites More sharing options...
Orlando Posted October 26, 2007 Share Posted October 26, 2007 Hi Gessie Have a look at the GetAsCSS function. Create a new calculated field with the formula 'GetAsCSS ( YourTextField )' and then do a search for "#FF0000" or whatever the colour used is. I have never tried this but I think its the only way to search on formatted text. Regards Orlando Link to comment Share on other sites More sharing options...
Lee Smith Posted October 26, 2007 Share Posted October 26, 2007 check this Custom Function Post Link HTH Lee Link to comment Share on other sites More sharing options...
gessie Posted October 27, 2007 Author Share Posted October 27, 2007 Hi Orlando Many thanks for your input. Did just as you said - and then went searching for the colour in question gessie Link to comment Share on other sites More sharing options...
gessie Posted October 27, 2007 Author Share Posted October 27, 2007 Hi Lee Many thanks for your response. I found Orlando's post first and managed to do just what I wanted to do using the GetAsCSS function. It didn't stop me from checking out the GetAsStyledText script that you suggested though. More ways than one to skin a cat - and I learned something from each of your suggestions. Cheers gessie Link to comment Share on other sites More sharing options...
Orlando Posted October 29, 2007 Share Posted October 29, 2007 Glad it worked for you gessie, I am always a little apprehensive when recommending something I have not used myself. It does look like a good feature that I will no doubt get around to using at some point. Take care Orlando Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6159 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now