MS Access 97

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I set the formatting of certain fields when I output the form data
into excel? My formatting is lost when (i.e. 5,210 changes to 5,210.00)
 
How do I set the formatting of certain fields when I output the form data
into excel? My formatting is lost when (i.e. 5,210 changes to 5,210.00)
Click to expand...

Use the Format() function as a calculated field in a query: rather
than exporting Numfield, export

ExpNumfield: Format([numfield], "#,##0")

to explicitly cast the field as a string. Export ignores any format
properties applied to the field.

John W. Vinson[MVP]
 
Back
Top