There are two ways to specify font and other text styles in FileMaker. You can select the text itself in a text field and specify a style or you can enter layout mode, select the field and specify a text style. The style applied directly to the text supersedes the text style specified for the entire field. When you copy and paste this text, you are also pasting its style--including the text size and this is keeping you from changing the text size on your labels.
Here's a fix that will allow you to keep using copy and paste:
- Open Manage | Database | Fields and find the field definition for your address field (or fields).
- Double click the field definition and select the auto-enter tab.
- Select the calculated value option.
- Enter this calculation: TextFormatRemove ( self )
- Click Ok and also clear the "do not replace existing value..." check box.
- Now, when you paste text into this field, the formatting will be automatically removed for you.
To clean up existing data, you can perform a replace fields operation on this same field, using the same function but replace self with the actual name of the field. (If Replace Field Contents is new to you, make a back up copy of your file first as this function can modify data in every record in your table all in one step.)
Another option is to just define a calculation field as TextFormatRemove ( AddressField ) and place that field on your labels layout, but I prefer to have such data be "clean" of formatting from the start.
Thanks for getting back to me.
Works a treat. Many Thanks.
Thanks a lot. The only thing I couldn't manage was your suggestion in your first bullet, where you say you can select multiple fields. Indeed you can but when double clicking no dialogue box appears. This box does appear however when you select only one field (one line in the box).
Of course I may be overseeing something.
Well, I didn't mean that you could select multiple fields and change them all in one go, just that you may have more than one field to which you need to make this change. You have to select them and change them individually.
Right. Typically a semantic misunderstanding.