apply 'save formatted' to reading?

[tenchy]

I have a DB with tables where the primary key fields are autoincremented, but with formatting applied.

Formatting is for example "CC"000000 so record 1 will be CC000001.
(each table has a different alpha prefix)

This works fine, except the database content is being read by another application, and it sees only the 1, 2, 3 etc.
Exporting the data to Excel format proves that this is due to Access not the other application.

However, if I export to Excel format, and tick the "Save Formatted" option, the data exported is as I require, CC000001, CC000002 etc.

Is there a setting or way to make Access present the data when it is read by another application to be the 'formatted' version of the data?

 

[Dennisk]

formatting in this instance is only relevent to MS office.
To get around this you will have to store the prefix in a seperate column and do away with formatting.

 

[neileg]

You could create a query and use a calculated field that returns the formatted result. Point the external application at the query instead of the table.