Solved

FileMaker text field not hyphenated properly

Posted on 2011-02-13
7
698 Views
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.
0
Comment
Question by:yballan
  • 3
  • 2
  • 2
7 Comments
 
LVL 24

Accepted Solution

by:
Will Loving earned 250 total points
Comment Utility
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...
0
 
LVL 4

Expert Comment

by:challengeday
Comment Utility
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.
0
 

Author Comment

by:yballan
Comment Utility
Sure, here it is.  Please look at SAT or ACT field.
Picture-1.png
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
LVL 4

Assisted Solution

by:challengeday
challengeday earned 250 total points
Comment Utility
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).
0
 

Author Closing Comment

by:yballan
Comment Utility
Thank you, both, at least now I can stop searching.
It is too bad, though
0
 
LVL 24

Expert Comment

by:Will Loving
Comment Utility
Be sure to go to http://www.filemaker.com/company/contact/feature_request.html 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.
0
 

Author Comment

by:yballan
Comment Utility
OK I will.  Thank you!
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

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…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now