change control feature while browsing records

[Jimmy Stewart]

this will probably seem like a lame question but it is baffling me.

I want to change the features if a control on a single form, i.e. the text
color of a particular field if another check box is checked. in other words,
if the check box for a flagged customer is checked, I want the customers
name to be red...

If Me.Inactive = "True" Then
Me.Client.ForeColor = 255
End If

Problem is, I don't know where to put this. If I put it in the OnLoad,
OnCurrent, etc. events it works fine if I open the form to that record. How
can I get the form to check this each time the record is changed, i.e. if
the user is browsing through the records one at a time?

[Rich P]

Not to clear what your situation is, but here is something you can try
for the following scenario:

You have a form is single form view. The datasource of the form is
based on some table. The datasource (the table) contains a yes/no field
(a checkbox field) called "YesNo". You can add code like the following
the form's current event:

Private Sub Form_Current()
If Me.YesNo = True Then
fldx.ForeColor = VbRed
Else
fldx.ForeColor = VbBlack
End If
End Sub

You have to remember to change the color of the textbox back to the
original color if the yes/no condition is False.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

[Bas Cost Budde]

The Current event will fire when the user navigates to another record.
Plus, it fires twice during the Load sequence of the form. Your code
deserves to be in the Current event procedure; be sure to check the Nz()
values of your fields as to circumvent errors during the initial calls.

Jimmy Stewart schreef:

this will probably seem like a lame question but it is baffling me.

I want to change the features if a control on a single form, i.e. the text
color of a particular field if another check box is checked. in other words,
if the check box for a flagged customer is checked, I want the customers
name to be red...

If Me.Inactive = "True" Then
Me.Client.ForeColor = 255
End If

Problem is, I don't know where to put this. If I put it in the OnLoad,
OnCurrent, etc. events it works fine if I open the form to that record. How
can I get the form to check this each time the record is changed, i.e. if
the user is browsing through the records one at a time?

--
Bas Cost Budde
Holland
www.heuveltop.nl/BasCB/msac_index.html

[Jimmy Stewart]

Not really sure what was going on before, but I added your code to the
OnCurrent event and it works great. I must have had some syntax problems
with my code?

"Rich P" <rp*****@aol.comwrote in message
news:45***********************@news.qwest.net...

Not to clear what your situation is, but here is something you can try
for the following scenario:

You have a form is single form view. The datasource of the form is
based on some table. The datasource (the table) contains a yes/no field
(a checkbox field) called "YesNo". You can add code like the following
the form's current event:

Private Sub Form_Current()
If Me.YesNo = True Then
fldx.ForeColor = VbRed
Else
fldx.ForeColor = VbBlack
End If
End Sub

You have to remember to change the color of the textbox back to the
original color if the yes/no condition is False.

Rich

*** Sent via Developersdex http://www.developersdex.com ***