FileMaker text field not hyphenated properly

Posted on 2011-02-13
Last Modified: 2012-05-11
Dear Experts,
I am Using FileMaker Pro 11, and converting Access Database.
It was automatically hyphenated as in word-wrap in Access, but FileMaker just breaks up the word when it does not fit in one line.
Is there a simple way to fix this problem?  Please advise.
Question by:yballan
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
LVL 25

Accepted Solution

Will Loving earned 250 total points
ID: 34882993
To my knowledge, FileMaker, for all the things it can do, does not support hyphenation, either in text fields or in text blocks on a layout. You would think that after 24+ years of development, that this would have come up and been addressed...

Expert Comment

ID: 34884553
Hi yballan,

Can you give a specific example (or screen shot)?

 In my experience I haven't seen FM break up a word, but simply put the entire word on the next line, in which case hyphenation is not necessary.

Author Comment

ID: 34884596
Sure, here it is.  Please look at SAT or ACT field.
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.


Assisted Solution

challengeday earned 250 total points
ID: 34884861
I see, the field is smaller than the word.

I agree with willmcn, FM doesn't provide hyphenation in this case. My guess is that it would add processing time to every field to check hyphenation rules.

I would recommend making a list of the possible values in that field and then making the field long enough to accommodate the longest one. You can see such a list by clicking in the field and doing Ctrl+i (on the pc)

 In layout mode you can do View>Show>Sample Data and that will give you an idea of the number of characters the field will show.  

The only reasons I can see to squeeze fields are if you are trying to fit them to a screen size or a print page size.

Two other solutions are to reduce the text size of the field so more data will show, or to replace the long word in the data with an abbreviation (such as "Rec" or "Recom").

You could also leave as is since it *is* understandable (although not pretty).

Author Closing Comment

ID: 34888890
Thank you, both, at least now I can stop searching.
It is too bad, though
LVL 25

Expert Comment

by:Will Loving
ID: 34889265
Be sure to go to and enter it as a feature request. You won't be the first or the last to do so on this topic, but the more requests they get the more likely it is to happen.

Author Comment

ID: 34889278
OK I will.  Thank you!

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question