Changing existing data to default font

[cschmitz]

Hi. I have a quick question about fonts. This particular problem has to do with filemaker 6 which I am unfamiliar with, but its also a question I have for all versions of filemaker.

 

I have users that has a filemaker 5 database with records already entered into it. The font format of the data in the fields is not always consistent. They have gone through and set the default font type to what they want (CG-gothic), but they want to change the format of all of the existing data to the default font type. How would you go about doing this for all existing data in filemaker 6 (and in any version of filemaker)?

[AHunter3]

For FileMaker 6 there are no text formatting functions per se, but you can try creating a calc field, result type text (assuming the original field is a text field?), formula =

 

Left ("x", 0) & OriginalField

 

then run a looping script like so:

 

Loop

Set Field [OriginalField, NewCalcField]

Go to Record [Next, Exit After Last]

End Loop

[cschmitz]

Cool, I'll talk to the users and give it a try. Thanks!