Data entry in Access 97 Form

Offhand, the only way I can think that you could do this is by using macros. You could create a macro that changes the background color to yellow and one that changes it back to whatever is the norm. Then you could set the field properties to run the first macro on "Got Focus" and the second on "Lost Focus". Of course, you'd have to set these properties individually for every data entry field on the form. You could do this globally by selecting all the data entry fields together (after you've finished designing the form) and then choosing properties for all fields at one time. Hope this helps!

Create a form with two fields named Field1 and Field2 Paste the code to the code module. In Properties set the OnEnter and OnExit to [Event Procedure]for both Field1 and Field2.
'Start Code
Private Sub Field1_Enter()
Me.Program.BackColor = 65535
End Sub

Private Sub Field1_Exit(Cancel As Integer)
Me.Program.BackColor = 16777215
End Sub

Private Sub Field2_Enter()
Me.Requirement_Id.BackColor = 65535
End Sub

Private Sub Field2_Exit(Cancel As Integer)
Me.Requirement_Id.BackColor = 16777215
End Sub
'End Code

I really don't have a solid answer from myself. I say do what the guy right above did. Do it in code. I NEVER use Macros. Writing your own VBA always turns out to be better in the long run. Just a bit of advice!