keep the format such as capitalization of data when exporting

[Kath]

I formated the Capitalization in Forms and Tables so when
I am inputing I can save some trouble. Yet the data's
format don't carry through when they are exported. What
did I do wrong?

 

[Joe Fallon]

Perhaps you only display the data the way you want.
It may not actually be stored that way.

Open the table and look at the raw data.
If it is not formatted then you need to write a query and format each field
and then export the query.

 

[Guest]

thank you Joe for the reply - May I ask how do you do that
in the query?

Many Thanks!

 

[Joe Fallon]

Use the format function.

e.g.
Field Name = Amount
Value = 1

in query:
myFormattedAmount: Format([Amount],"##,###.00")