Need help to format a field. Is it possible when I enter data in a lower case to a field and tab to go to next field and the DATA I enter into previous field automaticaly changes to upper case. [color:"blue"]

In FMP 7, define the field to auto enter the calculation

Upper (field)

Also, uncheck the option below the Auto Enter Calculation

Do not replace existing values (if any)

With this unchecked, each time you modify or enter information in that field it will perform the auto enter calculation again, ensuring data integrity past the first instance.

Thanks Andy, great tag-team work there.

Vaughan -

you are welcome.

Now, when can we talk about setting up the first official "FMPug" of Australia.

Funny you should mention that... PM me and we'll chat about it.

Thanks Vaughan and Andy. I tried that before posting my problem, but it did not work. After reading your posts I went back and tried again it work.

Thanks Again