TextFont AND TextSize functions in calculation - Is it possible?

[Mark Bowen]

Hi there,

Sorry for the long subject, I hope it all shows up on the forums as I haven't been here for quite a while.

I was wondering if someone could possibly help me out with a slight quandary that I am having at the moment.

I need to export data from Filemaker V7 as a PDF. I can lay out the data and export as PDF with no problems. The only problem that I am having is that people who are using the database are copying and pasting text into fields instead of just writing it in and so I am getting all kinds of different fonts and font sizes appearing in the fields.

I saw that it is possible using Auto-Enter -> Calculated Value that I could do this

TextFont ((Client) ; "Verdana")

This is great but I also need to be able to specify the size as well using 

TextSize ((Client) ; 10)

Is there any way that these two functions can be used within the same Auto-Enter calculation?

I can't unfortunately use a script to do this as it is every single time someone types into certain fields so this would be impossible to catch and I am only on Version 7. Not sure if there are new functions in V8 but cannot unfortunately afford to upgrade all of our database clients for the considerable future so was wondering if there is any way around this?

Any help with this would be massively appreciated.

I'm sure it is probably just me and there is some easy way of using more than one function in an Auto-Enter calculation but I really do have quite limited knowledge of Filemaker and everything always falls to me to have to figure out instead of an outside company being paid. To save money obviously!!

Thanks again for any help with any of this.

Best wishes,

Mark

[Søren Dyhr]

Is there any way that these two functions can be used within the same Auto-Enter calculation?

There is - if you make the above search on this:

http://www.databasepros.com/resources.html

Will you get 4 pages of tips - just up your street!

--sd

[Lee Smith]

you can combine these Functions.

TextSize ( TextFont ( Client ; "Verdana" ) ; 10 )

HTH

Lee

p.s.

I see that Soren posted while I was typing. His point to www.databasepros.com site is an excellent suggestion. I haven't read the particular file he has pointed to, but if it is on John Mark Osborne's site, then you will find it helpful.

Edited July 6, 2007 by Guest
p.s.

[comment]

You can nest the two functions, as shown above - but for your purpose you shouldn't use either one of them. Instead of forcing a particular style, you should REMOVE all styling from the text.

The difference is this: unstyled text will be shown in the style defined in Layout mode; you can have the same field show as Verdana 10 on one layout, and as Courier 12 on another. OTOH, styling the text itself will override layout settings - it will be Verdana 10 EVERYWHERE.

To remove all text styling in v.7, you can use a auto-entered calculation (replacing existing data) =

Evaluate ( Quote ( Yourfield ) )