A READER ASKS: Button To Make Selected FileMaker Text UPPERCASE

From Dwayne Wright PMP
Certified FileMaker Developer

WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

A READER ASKS
I enjoy your columns.  I need to format into capital letters a lot, and for years I've tried, unsuccessfully, to create a button so I could turn any word or sentence (not the entire field) into UPPERCASE, without scrolling up to the Format/Style/UPPERCASE menu.

Any ideas?  I use FileMaker Pro Advanced v.8 for the Mac. If there is no button available, do you know if v.9 or 10 have this feature?

-------
DWAYNE RESPONDS
I don’t know of a way to do this purely with FileMaker “out of the box” resources. I could have spent some time investigating this but I cruised over to the custom function library on briandunning.com to see if there was a custom function that would do the trick.

I didn’t see one of them but I did see three of them that would work. Thinking about it now, I guess I could have tried experimenting consolidating the code of all three into one but I’ll leave that experiment up to you.

getActiveSelection - http://www.briandunning.com/cf/595
Returns selection in a text field.

RightofSelection - http://www.briandunning.com/cf/1049
Gets the string to the right of the active selection text. If there is no selection, returns nothing

LeftofSelection - http://www.briandunning.com/cf/1048
Gets the string to the left of the active selection text. If there is no selection, returns nothing

Using these three custom functions, I set a field equal to itself with the following calculation ...

LeftofSelection & Upper(getActiveSelection) & RightofSelection

© 2010 - Dwayne Wright - dwaynewright.com
The material on this document is offered AS IS. FileMaker Pro is the registered trademark of FileMaker Inc.