Datasheet subform format question

[Dylan Snyder]

I have a subform that is in Datasheet view. what I want to do is format certain rows of the datasheet with different backcolors. When I write it in code or simply change the backcolor in the field in design view, the field in design view changes but the datasheet remains white. Am I wasting my time?Does datasheet view prohibit color changes...etc? Thanks

 

[KeithG]

You can chang the color of the lines on the form but not the back color in datasheet view. Have you tried using continous form view?

 

[Dylan Snyder]

Thanks, The users want to go with datasheet. What do you use to change the color of the lines? I tried changing the border color on the field but that didn't do it.

 

[namliam]

You can make a continues for "look like" a datasheet by putting the controls right next to eachother... OK it is not the same but pretty close and you have all these "french benifits" of doing conditional formatting and stuff

 

[Dylan Snyder]

yeah, you're right. If I got rid of the shadows and made every field white I could get it to look pretty similar. Thanks. Honestly hadn't thought of that.

 

[missinglinq]

You can, indeed, format the BackColor of fields (textboxes) in Datasheet View forms, but only by using Conditional Formatting found under Format on the Main Menu. You 're limited to 3 colors plus the default. Exactly what are you trying to do?

 

[Dylan Snyder]

you're right. That does work. Basically, I'm trying to highlight a single field red if the value is over a fixed number. The conditional formatting solves this problem.

 

[missinglinq]

Glad it works for you!