adapt imported data to the right text style

[hpw]

Hi there

We started to use a FMP solution for our contact data management. Therefore, I imported data from various excel docs and somehow together with the import of the contact data some style data was imported too.

Means: when I go through the FMP database now the data appears in different styles on the layouts. Text in the field is sometimes grey, sometimes black, sometimes arial, sometimes some other lettertype. It hurts my eyes and it looks unprofessional.

How can I force the data to be showed in the style I defined when creating the layouts? Do I have to write a script and let it run through the whole data mountain to remove text styles? Or do we have an elegant solution?

thanks for any help

Hans

[Søren Dyhr]

You could provide your fields with a autoenter with update function, like this:

http://www.filemakerpros.com/FieldFilter7.zip

Where the calc' you facilitate your fields with, could be this:

http://www.filemaker.com/help/FunctionsRef-397.html

Now this will deal with future imports, and to make it deal where the "damage" already is done, should you re-export to a temporary file and then reimport it again to make the new calc's make thier wonders.

--sd