learning Posted April 10, 2004 Share Posted April 10, 2004 Is there any easy way to create a script to find all of one name in a database and change the text color for just that name?? For example, I have a database that gets the names of people from a value list. The names are formatted title case and all black. I want to find all Joe's and change to red color. could someone tell me how to do this?? I am going through database now and changing each occurence of Joe manually. Thanks Larry FileMaker Version: 6 Platform: Windows 95/98 Link to comment Share on other sites More sharing options...
Ender Posted April 10, 2004 Share Posted April 10, 2004 I don't think FM6 can be automated to do this, but FM7 can. Link to comment Share on other sites More sharing options...
learning Posted April 11, 2004 Author Share Posted April 11, 2004 Could someone show me the steps to doing it with ver 7? I might upgrade. Thanks Larry Link to comment Share on other sites More sharing options...
Ender Posted April 11, 2004 Share Posted April 11, 2004 Theoretically you do this with a simple Find/Replace Find: <Name> Replace With: TextColor ( <Name> ; RGB ( 255 ; 0 ; 0 ) ) Though I can't get that to actually work. Maybe the text color feature doesn't work in Find/Replace. Instead you could create a global that will contain your search text, then script the replacement: Go to Record/Request/Page [ First ] Loop Set Field [ MyField, Substitute( MyTable::MyField; MyTable::Search Text; TextColor ( MyTable::Search Text ; RGB ( 255 ; 0 ; 0 ) )) ] Go to Record/Request/Page [ Exit after last , Next ] End Loop This will replace the actual field contents with the colors of the search text. You should consider just using a calc field that shows the highlighted color on those layouts that need it, instead of replacing the data. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7318 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