keep the format such as capitalization of data when exporting

  • Thread starter Thread starter Kath
  • Start date Start date
K

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?
 
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.
 
Use the format function.

e.g.
Field Name = Amount
Value = 1

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