I have a database with lots of data and people have changed the font when they enter the data. I now need to standardize the font throughout.

If I go to layout and set the font this does not appear to change it in all the records. Is there a way of doing this globally.

Also is there a way of stopping users from changing the font details set for a field?

Many thanks for the help.

A quick manual way to reset all fields to the layout's field format is to find all records, export all fields to a text file, save a clone, and import the text file back into the clone. (I personally export to a merge text file so I can confirm file mapping when I reimport)

If only a few fields are the target of your "field formatters", you can create a looping script that steps through each record and sets the field with its own contents (Set Field, <targetfield>, <targetfield>. This can take a while in a big database, especially if you have a lot of target fields to reformat.

As for keeping users from reformatting the text, if policy, knuckle rapping, threats and whining don't work, you could script the data entry to use the above mentioned set field steps whenever the user exits the record or exits the field, using a script scheduling extension such as offered by Troi or Waves In Motion.

Others may have better solutions, so I hope they chime in.