text field formatting upon submission or up date

[alphanitrate]

how can i have commands like TRIM, UPPERCASE used on a field so that it will display correctly, and export correctly? I'm not exactly sure how to make this happen. Ideally it would occur after a record was modified.

[Lee Smith]

You can use the Auto Enter by Calculation, and gang the calculation like this

Trim (Upper( Text ))

Take a look at this Thread to see how it is done. Link

Edited June 5, 2009 by Guest

[comment]

Note that neither Trim() nor Upper() are formatting functions - they modify the text itself.

[alphanitrate]

Lee - that worked awesome. I'm going to post 2 other issues i have and I hope that I get such a great response as yours. Thank you so much!