Access Datasheet View

[kiransalu]

I am using Access 2002 for my new project. I have created a form from a table and changed it to datasheet view. The datasheet view contains 24 columns...It contains 35 records in the view.

Based on my first column in the third row value, i would like to disable 3rd,4th and 5th column in the third row. How would i do that?

Mhy first column is a combo box. On the value selected from the combo, i tried to disable the other columns in the same row.... but all the rows in these columns are getting disabled?

Is there any way to access individual cells in datasheet view?

 

[PHV]

Have you tried Conditional formatting ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[kiransalu]

What is this conditional formatting? How do i use this? Could you be more specific.....

 

[PHV]

No F1 key on your keyboard ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244