Can't change font size of related field

[ibiubu]

Strangest thing. I have a related field (not in a portal). I can change the font, but I can't get the size of text in the field to change. No matter what font I pick, it always stays at 10pt. I dont seem to have trouble changing the point size in similar related text fields, just this one. It has me baffled.

Anyone come across anything like this before?

LR

[Lee Smith]

There are two ways to effect text styles.

One is to format the field in Layout mode by choosing it, and then selecting the different text attributes desire from the Font Menu. If, this was what you are doing, without effecting what is in the field, then I suspect that the text was pasted into the field.

If this is the problem, then you will need to replace the data in the field with itself. There are a couple of ways to do this, I would use the "Replace" function in the Menu.

Note: there is no way to reverse this action, so practice on a copy of the file.

First put your cursor in the field to be changed. Then, go to Menu - Records - Replace. Select Replace by Calculated Results. In the Calculation box put Substitute(YOURFIELD, "","")

Note: the YOURFIELD needs to be the field you are changing and has your cursor in it.

If you need to more information on how to do this, let us know.

Also, to avoid this in the future, do you pastes without format (Cmd - ops V on the Mac).

THT

Lee

[BobWeaver]

I had exactly the same problem a couple of days ago. Here is how I solved it. Go into layout mode and delete the field from the layout, and then put in another copy of the field. Now go back to browse and try again. You may also have to copy the data out the the field into a text editor and change the font, and then paste it back into the field. Once you get the text style to work, then it should keep working.

[ESpringer]

For the problem Lee mentions (stuff having style attached when that's not desirable), I have a scriptlet called "remove style" in all my databases. Invoke it with cursor in the relevant field.

Select All

Cut [select]

Go to Previous Field

Go to Next Field

Past [select, No Style]

It can then be embedded in a loop that runs through found records, etc.

I'm not sure that this was the original issue, though... In general, in FileMaker, style information is (I think?) either all-there or all-not -- which is very awkward if one wishes to preserve italics but not font and size across layouts (quite necessary for quotations in academic contexts!). It seems ibiubu had a situation where some style info was maintained in a field's data and other style info was not. If that's possible, I'd like to know how to do that on purpose!

[BobWeaver]

I suspect this could be a bug. I have never encountered it before. But then, I rarely use format other than the field default.