From Dwayne Wright PMP
Certified FileMaker Developer
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?
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.