Is there a way to keep the program from applying a format to numbers in the query grid when I click on them?
Very annoying “feature”. Have several fields with long ID numbers and such. When I click on one of these on a query grid to copy to the clip board to use in the criteria for another query, TDA applies a format to the cell… ie. 456231656 becomes 456,231,656. and the commas go to the clip board along with the rest of the number. I’m constantly having to remove the commas when pasting the numbers in as criteria in a query. The commas aren’t there when viewing the grid. They do not appear until you click into the cell to select the data. Weird.
I’ve tried changing several things in the options, but apparently haven’t found the correct one if it exists. Is there a way to turn the feature off? Any help would be appreciated.