I'm working with an Access Runtime database. I had to split it in order to be able to make modifications to the user interface. I cannot modify the backend database directly - I can only do it through code. (If I could do it directly, this wouldn't be an issue
) As far as I know, I cannot add references or change settings like that in the back end database.
Anyway, I finally found a work-around. Not pretty or proper, but it gets the job done! Since the field is in a temporary table whose sole purpose in life is to export records to a text file, I can get away with storing the data in a text field. The numbers and decimal point is there, the dollar sign isn't and the program it geting imported into appears to be happy.
Thanks fo all your suggestions and help!