YES/NO Field - Excel to ACCESS - Question

[TryTryAgain]

I have an Access application that creates a table and uses TransferSpreadsheet to send it to Excel. Included are several Yes/No fields, which convert to "TRUE" and "FALSE" in Excel. The user updates the Excel spreadsheet and clicks on a button in the Access application to transfer it back to Access, where several reports are set up.

Question - the user wants to be able to enter just "T" or "F" or "Y" or "N" in the excel spreadsheet in the YES/NO fields. Is there any way to allow this and recognize it in Access? It appears that anything other than "TRUE", "FALSE", "YES", "NO", -1, and 0 convert to FALSE in Access.

 

[Ashank4vba]

What about auto complete in excel? If a person can enter TRUE or FALSE in one cell, subsequent ones can be filled by autocomplete with the starting letter right?

Thats a lazy solution, but worth a try?