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?
 
Computer101Connect With a Mentor Commented:
PAQed with points refunded (500)

Computer101
EE Admin
0
 
dqmqCommented:
I don't think that is possible without addons.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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)PresidentCommented:

  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)PresidentCommented:
<<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
All Courses

From novice to tech pro — start learning today.