problem with value list formatting

[swf]

See the attached file. Users enter in names with different formatting which looks ugly in a drop down list. For consistency (all caps) I created a calculated field combining first and last name. I formatted the calculation to be uppercase. However when creating a drop down list on data_entry_field based on this calculated field (cap_combined) the formatting is lost. Some names are caps, some lowercase etc. Is this a filemaker flaw?

test5.fp7.zip

[Kent Searight]

I've tried a number of ways to make a list appear the way you want and it appears that however the value is entered by the user (or script) is what you're going to end up with in your value list.

The only decent option I see for you is to choose a font for the field with the value list that's excusively uppercase. I'm not sure if any all-uppercase fonts come with Windows (or Mac OS for that matter)

[Lee Smith]

Try

Upper(last) & ", " & Upper(first)

Instead.

HTH

Lee

[Kent Searight]

Good going, Lee!

I don't think I'd ever paid any attention to the Upper(), Lower(), and Proper() functions before.

[swf]

That is exactly what I wanted. Looks much better. I guess the difference is that it actually changes the data vs. changing the format of the existing data.

thanks