I have entered all my data in lower case and now would like to chane to upper case in all layouts. I can do this manually but when I export the data even though in all alyouts it is now uppercase it still exports as lower case.

how many fields do you have? assuming you have a few you could just loop through your records using a step that converts the field to uppercase i.e.

setfield[table::field; uppercase(table::field)]

... or you could specify seperate calculation fields that would equal

uppercase(table::field)...

other than that, i cant think of anything...

~genx

Beginning with v7, there are two functions called, TextStyleAdd and TextStyleRemove, and depending upon what you need to do, will determine a lot of how you will use them.

Changing lower to upper, isn't all that hard, you can use a second calculation field for each field involve, your can use a script and change the fields either one record at a time, or a found set of records using a Replace through the menu, or a Loop script.

You can also use the Auto Enter Function when importing, creating a new record or modifying an existing record. You didn't mention the number of fields involved and records. So I'll just suggest that you use a loop scrip and the set field, with a calculation of TextStyleAdd (YourField; uppercase).

BTW, there is an Online Help that can explain this a little better, but if you need more help, let us know.

HTH

Lee