June 5, 200916 yr 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.
June 5, 200916 yr 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, 200916 yr by Guest
June 5, 200916 yr Note that neither Trim() nor Upper() are formatting functions - they modify the text itself.
June 8, 200916 yr Author 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!
Create an account or sign in to comment