TryTryAgain
Programmer
I have an Access application that transfers a table to Excel (transfer spreadsheet function). Users then update the Excel spreadsheet. The user can then click a button to re-convert the spreadsheet back into Access. My question is - when a yes/no field is transferred from Access to Excel, the values of TRUE and FALSE are the results of the transfer in Excel. The user wants to update these fields with a "Y" or "N" or "T" or "F", rather than entering the entire word. Is there any way to allow that and convert it with code in a module? I can't find any solution, except to tell them to use a -1 or 0 if they want to limit their keystrokes. Anyone?? Thanks!
