Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Formatting columns in datasheet view 2
- Thread starter krets
- Start date
Bandenjamin
Programmer
Make sure that your formatting toolbar is selected. Switch to datasheet view and select the background color that you want using the button. If the color selectors are not there then right click on a blank area of toolbar and select "Formatting (Datasheet)" (The datasheet part will appear when you are in datasheet view mode)
Hope that helps.
Dan
Life should NOT be a journey to the grave with the intention of arriving safely in an attractive and well preserved body. But, rather to skid in sideways, chocolate in one hand, martini in the other, body thoroughly used up, totally worn out and screaming ~ WOO HOO what a ride!
Hope that helps.
Dan
Life should NOT be a journey to the grave with the intention of arriving safely in an attractive and well preserved body. But, rather to skid in sideways, chocolate in one hand, martini in the other, body thoroughly used up, totally worn out and screaming ~ WOO HOO what a ride!
- Thread starter
- #3
-
2
- #4
TheAceMan1
Programmer
How are ya krets . . .
Have you tried [blue]Conditional Formatting?[/blue]
See Ya! . . . . . .
Have you tried [blue]Conditional Formatting?[/blue]
- Thread starter
- #5
I haven't. How flexible is Conditional Formatting though?
What I have is a crosstab query in datasheet view that is counting the number of errors that a technician has made. Each column corresponds to an error and the data will be the number of times the tech has made that error.
The errors have a Severity of either Major or Minor and I'd like to shade those that are major to make them stand out.
What I have is a crosstab query in datasheet view that is counting the number of errors that a technician has made. Each column corresponds to an error and the data will be the number of times the tech has made that error.
The errors have a Severity of either Major or Minor and I'd like to shade those that are major to make them stand out.
Bandenjamin
Programmer
Krets,
I tried AceMan's idea and it should work great for what you want.
Star for Aceman!
Dan
Life should NOT be a journey to the grave with the intention of arriving safely in an attractive and well preserved body. But, rather to skid in sideways, chocolate in one hand, martini in the other, body thoroughly used up, totally worn out and screaming ~ WOO HOO what a ride!
I tried AceMan's idea and it should work great for what you want.
Star for Aceman!
Dan
Life should NOT be a journey to the grave with the intention of arriving safely in an attractive and well preserved body. But, rather to skid in sideways, chocolate in one hand, martini in the other, body thoroughly used up, totally worn out and screaming ~ WOO HOO what a ride!
- Thread starter
- #7
TheAceMan1
Programmer
You can set up to 3 conditions, plus default . . .krets said:
Bandenjamin
Programmer
Krets,
I used Field is equal to "Major" and "Minor" (no quotes) you can actually set them to whatever text you want it to be if you only need the two. Like AceMan said, you can do up to 3 plus the default.
Dan
Life should NOT be a journey to the grave with the intention of arriving safely in an attractive and well preserved body. But, rather to skid in sideways, chocolate in one hand, martini in the other, body thoroughly used up, totally worn out and screaming ~ WOO HOO what a ride!
I used Field is equal to "Major" and "Minor" (no quotes) you can actually set them to whatever text you want it to be if you only need the two. Like AceMan said, you can do up to 3 plus the default.
Dan
Life should NOT be a journey to the grave with the intention of arriving safely in an attractive and well preserved body. But, rather to skid in sideways, chocolate in one hand, martini in the other, body thoroughly used up, totally worn out and screaming ~ WOO HOO what a ride!
TheAceMan1
Programmer
krets . . .
In [blue]form design view[/blue] select the field you want to format then [blue]MenuBar[/blue] - [blue]Format[/blue] - [blue]Conditional Formatting[/blue]. I think you can figure it out from here. If not . . . let us know (state your conditions if you return).
See Ya! . . . . . .
In [blue]form design view[/blue] select the field you want to format then [blue]MenuBar[/blue] - [blue]Format[/blue] - [blue]Conditional Formatting[/blue]. I think you can figure it out from here. If not . . . let us know (state your conditions if you return).
- Status
Similar threads
- Locked
- Question
