August 9, 200421 yr Hello people! Here is an image attached that explains my intentions the best..... I have tried formating this related VL in format of POP-UP (Title Case)text of this list and nothing seems to affect the "looks" of it....it still remains the same as entered...a mix of CAPS and very ugly formating/allignement... Any suggestion? desired look is on the right hand side: MANY thanx!
August 9, 200421 yr Why not use a second field, that is a Calculation based on your current Impute Field and have it use FileMaker's built in Proper, Upper, or Lower to change the format to what you want. In other words, if the text is being entered as All Caps (or some other mish mash), and you want it to be in Title Caps, then use the calculation function of Proper(text) to convert it. You can also do this with a script, or replace. HTH Lee
August 9, 200421 yr Author Excellent! Thank you Lee, I guess there is no really way to "force users" on "correct" entry....works like a dream! All the best!
Create an account or sign in to comment