Setting a simple condition for a field

[Tom B]

I am trying to create a simple application to track the "in" and "out"
of a group of employees. The In and Out field is a drop down. When it
is set to "in" I want the background of the filed to be green, and when
it is set to "out" I want the back ground to appear red. I would
appreciate some instruction and or sample VB code for such an
operation.

Thanks,
Tom B

[PC Datasheet]

If Me!InAndOutField = "In" Then
Me.Detial.BackColor = "65280"
ElseIf Me!InAndOutField = "Out" Then
Me.Detial.BackColor = "255"
Else
Me.Detial.BackColor= "-2147483633"
End If

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!

"Tom B" <tj********@comcast.net> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

I am trying to create a simple application to track the "in" and "out"
of a group of employees. The In and Out field is a drop down. When it
is set to "in" I want the background of the filed to be green, and when
it is set to "out" I want the back ground to appear red. I would
appreciate some instruction and or sample VB code for such an
operation.

Thanks,
Tom B

[Randy Harris]

"PC Datasheet" <no****@nospam.spam> wrote in message
news:Gk****************@newsread3.news.atl.earthli nk.net...

If Me!InAndOutField = "In" Then
Me.Detial.BackColor = "65280"
ElseIf Me!InAndOutField = "Out" Then
Me.Detial.BackColor = "255"
Else
Me.Detial.BackColor= "-2147483633"
End If

He meant to say Detail.

[PC Datasheet]

Thanks, Randy!
It's good to see a courteous response by you!!!!!

Steve
"Randy Harris" <ra***@SpamFree.com> wrote in message
news:wy****************@newssvr24.news.prodigy.net ...

"PC Datasheet" <no****@nospam.spam> wrote in message
news:Gk****************@newsread3.news.atl.earthli nk.net...

If Me!InAndOutField = "In" Then
Me.Detial.BackColor = "65280"
ElseIf Me!InAndOutField = "Out" Then
Me.Detial.BackColor = "255"
Else
Me.Detial.BackColor= "-2147483633"
End If

He meant to say Detail.

[Tom B]

Thanks for the quick reply and the code worked beautifuly. However I
had a mistake in my description. I want only the back color of the text
box to change, not the color of the entire form.

Thanks again for the help,
Tom

[Keith W]

"Tom B" <tj********@comcast.net> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

Thanks for the quick reply and the code worked beautifuly. However I
had a mistake in my description. I want only the back color of the text
box to change, not the color of the entire form.

The syntax would be "Me.txtMyTextBox.BackColor = " where txtMyTextBox is the
name of your control.

Keith.
www.keithwilby.com

[Tom B]

Thanks Keith