There are two ways to control the font type selection for text in FileMaker. You can specify it for the actual text in a field. You can, for example, select some of the text in a field and specify a font for it just like you would in a word processor. On Macs, you can copy and paste the text with it's style into a field.
You can also select a field while in layout mode and specify a text style, such as a font, for it. When the text in the field has a font specified as well as the field, the text style selected for the actual text supersedes the style specifications for the field.
You can clean up your imported text with Replace Field Contents.
- Wait until you can do this when no one else is editing these records.
- Make a back up copy of your file.
- Select Show All Records
- Click in the text field and select Replace Field Contents.
- Use the calculation option with this function: TextFormatRemove ( YourFieldHere )
- This will strip out all the font specifications for you existing text so that the Helvitica selection you've made for the field will work.
I had some trouble to find the Replace Field Contents function I must say. In fact, I didn't find it. But you've posted another helpful contribution which I used to change the font type. Not in one go but field for field and it works very well.
See this Font size wont change.
Replace Field Contents is listed in the Records Menu.
And guess what: when you choose to go into lay-out mode there is no Records menu, hence there is no Replaced Fields Contents function.
So the solution is NOT to go into lay-out mode and choose a field while in browse mode. I don't know why I entered lay-out mode, I think it's because it already has become a second nature.
Thanks a lot for your patience!