Can a VL that uses field data be made to retain formatting? The ValueListItems function returns the text only as entered.

My VL in question is used in a function to compare to two VLs which does not work due to differences in capitalization of original data. Formatting the field using auto enter calcs does effect the data in the VLs.

If anyone is interested... I had to solve the issue by exporting the field data to another application to reformat the text, then import/update the data back into FM.

If you know a way to avoid this I would like to hear it.

I am not sure what exactly "formatting the field using auto enter calcs" means. I am guessing you have used TextStyleAdd() which doesn't affect the actual characters, only the style in which they are displayed (and is ignored by the ValueListItems() function). It would be different had you used one of the Text functions, such as Upper(), Lower() and Proper().

You nailed it.

Thanks for the education.

Had I only known...