Search results

Ryan, It works like a charm. I didn't know about the conditional formatting. Actually, the "Field Has Focus" option eliminates the need to write an expression. Thanks for your help John

Hi, In a subform, where several records are displayed, I would like to change the background color for the current control in the current record. I tried the following: ---On Enter--- Private Sub Job_Enter() ActiveControl.BackColor = Yellow End Sub ---On Exit--- Private Sub...

Trevor, Thank you very much for replying to my question. I wonder, is this so basic that all Access progammers would know it? No need to answer. At any rate, I printed out your textbook answer and stapled it in my access user guide manual. Thanks again. John Tamaro

Hello, Can anyone tell me what the difference is in the SQL generated in a query and putting that same code in a form? This is the SQL from the query: SELECT Employees.ID FROM Employees; This is what I put in the form: Private Sub Text1_Click() Dim SS SS = "SELECT...