Datasheet

[dogman01]

I have code that I built into a control in FORM view that changes the background color of the box based on a certain selected value and it works fine but when viewing the same form in DATASHEET view it does not work. Is this the way it's going to be or is there a workaround. Thanks

 

[namliam]

Thats the way its going to be...

You may do a workaround by using "Tabular" view instead, but that has it's limitations as well.

I sure hope you are using "Conditional formatting" or you WILL have problems with Tabular view.

 

[missinglinq]

Actually, formatting like this does work in Datasheet View as well as Continuous View (Tabular), at least in Access 2003. But as the Mailman indicated, it has to be done thru Conditional Formatting off of the Format Menu. You cannot do thru code in the Form_Current event as you can in a Single View form.

 

[namliam]

Oh cool I didnt know that.... conditional formatting in Datasheet view... Nice...

(does it show I am not up to that version yet??)

 

[missinglinq]

I figured tou were probably running 2000 or 2002? Conditional Formatting came in for Continuous Forms (Tabular) in 2000, I think, and moved up to cover Datasheet View in 2003. Just one of the many version-dependent things that can be confusing when answering questions here.