How do I control objects in a subform showns as datasheet ?

[FruStalin]

Hello Access people



Just a little question about controlling objects in datasheet shown in subforms.

Is it possible to control objects in at datasheet view? Please see the attached file.

I am thinking of changing colors on a field via VBA.
Example: [Forfaldsdato].forecolor = vbRed.
This works fine in a ordinary form, but not in datasheet view.

My goal is to change colors in sudden field according to some IF conditions . It must be possible when it works in form view.
Does anyone know how this this done?

Regards

Morten

[cowboy]

Why do you want your subform to be in datasheet view?

If it were me I would make it a continuous form and run the code on the oncurrent field of the subform. If you want a datasheet view you can still make it work

[FruStalin]

Hello Cowboy

I wish to have the Datasheet view for several reasons.
One main reason is to avoid having that drop down arrow from comboboxes visible all the time and off cause having many infomation at same time.

Is that possible the way you do it?

Regards

Morten