Format POP-UP list

[Leb i Sol]

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!

[Lee Smith]

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

[Leb i Sol]

Excellent!

Thank you Lee, I guess there is no really way to "force users" on "correct" entry....works like a dream!

All the best!