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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Background colour or selected row in datasheet view.. 1
- Thread starter blondends
- Start date
-
1
- #2
It can be done I think using conditional formatting.
Select a control - and then 'Conditional Formatting' from the format menu.
Set the new background for IF field has focus, then use the format painter to apply to all controls.
That will only change the field your in, but conditional formatting is the ONLY way I have found of dynamically changing a datasheets properties.
--
You COULD possibly have some hidden field that changes value when you enter a record, and changes back when you leave. Then have that as the criteria for the conditional formatting on the other controls.
Some food for thought
Select a control - and then 'Conditional Formatting' from the format menu.
Set the new background for IF field has focus, then use the format painter to apply to all controls.
That will only change the field your in, but conditional formatting is the ONLY way I have found of dynamically changing a datasheets properties.
--
You COULD possibly have some hidden field that changes value when you enter a record, and changes back when you leave. Then have that as the criteria for the conditional formatting on the other controls.
Some food for thought
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
