This question is getting off topic. Please ask as a new question for others to find results. Asking here never presents this question easily visible to others seeking a similar answer.
Edit: Not much else - Case may fit in places.
No problem Ratslinger I understand, I will spend a bit more wrestling time on this and post a new question if I can’t solve it.
Thanks again for the ASCII_CHAR() answer, much appreciated.
The number format of a value dispayed in a table or view does not matter at all if only the displayed value is correct. The grid view of a table or query is nothing more than a view on raw data.
Forms and reports constitute the user interface of a database. The controls in forms and reports allow any number format for dates, times and decimals.