Continuous Form Question

accesser

Registered User.
Local time
Today, 14:51
Joined
Mar 17, 2003
Messages
54
The problem is that I have a recordset Rosters.
Fields are ShftDay, A, B, C
The ShftDay is distinct field.
I have continuous form mapped to this recordser.
This continuous form have 4 text boxes, each is mapped to one of the recordset fields.
The user can edit these fields.
What I want to do is when the user enter the value "Na" in one of A,B or C textbox, I want the backcolor property of this textbox to become pink.
What I face is that for example if I enter the "Na" value in the A textbox, all the cells of the A textbox are converted to pink. What I want is only the cell in the edited record, not all.
Please Help Me.
 
Thank you very much Mr. Pat Hartman for your reply.
But I want is to automate the property setting fot the control by using the code.
For example I want to set the tag property of the current control to 2372 when the event LostFocus and the value of this control(textbox) is "Na".

suppose that the name of the textbox control is A. then the code I want is:

Private Sub A_LostFocus()
if A.value="Na" then
A.tag=2372
endif
End Sub


So Please see if it is possible to do this in Access.

Best Regards
 

Users who are viewing this thread

Back
Top Bottom