General discussion

Locked

Data entry in Access 97 Form

By learneverything ·
I have a very long data entry form I'm working on. In order to help those inputting to keep their place, I want the active cell to turn yellow, or something similar to draw attention. Thanks for suggestions.

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Data entry in Access 97 Form

by curlergirl In reply to Data entry in Access 97 F ...

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!

Collapse -

Data entry in Access 97 Form

by learneverything In reply to Data entry in Access 97 F ...
Collapse -

Data entry in Access 97 Form

by acwiz In reply to Data entry in Access 97 F ...

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

Collapse -

Data entry in Access 97 Form

by learneverything In reply to Data entry in Access 97 F ...

Thanks Fred! Speaking with you over the phone helped me get the full jist of your answer.

Collapse -

Data entry in Access 97 Form

by dtighe In reply to Data entry in Access 97 F ...

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!

Collapse -

Data entry in Access 97 Form

by learneverything In reply to Data entry in Access 97 F ...
Back to Software Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums