Hey folks--

This is probably a no-brainer and I think I may have even solved it before but for the life of me can't figure it out again:

For a given field I have the text format set to uppercase, but the Table View reveals that the raw data is not always in caps (depending upon how it is entered), but I want it all caps for data export.  How do I do this?  Thanks!

--Nate

hmmmm....

FYI, I played with this as a permanent programming code and not just mass update, and this is what I discovered:

Just writing:

MyField = ToUpper(MyField)

doesn't work because the computer seems to check the upper case display that is being showed and not the raw data, so nothing changes, the raw data still may be lowercase because the display is in upper case.

You have to do this:

var MyFieldUpper as String

MyFieldUpper = MyField
MyField = ""
MyField = ToUpper(MyFieldUpper)

which stores the info, clears it, and then rewrites it, changing the raw data too.