field for notes

[dharkin]

Hello,

In my database there is a field for notes. How can I keep the field fonts from being altered in size by the user. When a report is generated the font size is altering the size of the field.

[sbg2]

Create a new calculation field(Text, Unstored), name it something like calc_Notes.

calc_Notes = TextSize(Notes;#)

replace the # symbol with whatever size you want the text for your printout to be.

Use the calc field on your report rather than the actual Notes field.

[Ender]

Hi dharkin,

You might try giving your Notes field an auto-entered calc like this:

Evaluate ( Quote ( Notes ) )

Then uncheck the auto-enter option to "Do not replace existing value of field (if any)".

This will remove the formatting, and allow the text to use the default font of whatever layout the field appears in.

[bruceR]

Note that in FileMaker 8 there is a new function, textFormatRemove, that does exactly what you're looking for.