How to change background color of a particual cell in a datasheet form

Hi, guys
I have five different sub forms in a main form in Access. They are all in datasheet view. My problem is that I need to change background color of a particular cell when its data meet a pre-defined condition while it is being updated by user.
I dont' know is it possible to do so in datasheet view? Please help me.
Thanks a lot
HuongLT
huongltAsked:
Who is Participating?
 
Computer101Commented:
PAQed with points refunded (500)

Computer101
EE Admin
0
 
dqmqCommented:
I don't think that is possible without addons.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
huongltAuthor Commented:
Tks so much.
I'll try.
HuongLT
0
 
huongltAuthor Commented:
Hi, guys
What I' am allowed to do is using the standard controls which are available in MS Access only. Is there any other way to get my job done?
Please help me.
Thanks a lot
HuongLT
 
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:

  Another thing you can use, which is native to Access is a continuous form.  It can be made to look like a datasheet and you can control colors with conditional formatting or other techniques.

JimD.
0
 
huongltAuthor Commented:
Hi, guys
The continuous view will help solve the colors matter. However, it doesn't show me the record selector like the one in datasheet view (the record selector is just beside the datasheet and helps highlight the entire row when selected).

I'm still struggling looking for the solution to get my job done.
Please help me
Tks so much
HuongLT

0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<However, it doesn't show me the record selector like the one in datasheet view (the record selector is just beside the datasheet and helps highlight the entire row when selected).>>

  Sure it does.  Just make sure the forms Record Selector property is set to true.

JimD
0
 
huongltAuthor Commented:
Hi, guys
That record selector doesn't highlight the entire row like the one in datasheet view does.

HuongLT
0
 
huongltAuthor Commented:
Hi, guys
The conditional formatting is working well with the datasheet view. I got my work done.
Thanh all of you.
HuongLT
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.