Whenever we type keywords such as "recordset" or "string", VBA editor converts them to proper case, "Recordset" and "String", respectively.
I am now experiencing a problem such that whenever I write "recordset" it does not get converted to proper case (its initial letter is not capitalized). On the contrary, no matter how hard I try to rewrite it as "Recordset" or "DAO.Recordset", vbe converts it to lowercase, e.g. "recordset" and "DAO.recordset". Batch find&replace operations don't work either. Other keywords, such as "QueryDef.OpenRecordset" are not affected.
On the other hand, there's no function loss. the word is interpreted and evaluated by the compiler as the keyword it was intended to be, and everything works. However I find it very irritating and consider it to be a serious problem.
I tried copying, renaming forms and the database, without result. Any suggestions on how to fix it would be appreciated.
I am now experiencing a problem such that whenever I write "recordset" it does not get converted to proper case (its initial letter is not capitalized). On the contrary, no matter how hard I try to rewrite it as "Recordset" or "DAO.Recordset", vbe converts it to lowercase, e.g. "recordset" and "DAO.recordset". Batch find&replace operations don't work either. Other keywords, such as "QueryDef.OpenRecordset" are not affected.
On the other hand, there's no function loss. the word is interpreted and evaluated by the compiler as the keyword it was intended to be, and everything works. However I find it very irritating and consider it to be a serious problem.
I tried copying, renaming forms and the database, without result. Any suggestions on how to fix it would be appreciated.