Font Color in Datasheet View

  • Thread starter Thread starter Chaplain Doug
  • Start date Start date
C

Chaplain Doug

I am displaying data in a form in datasheet view. In
design mode I have set the font color to blue. But when
displayed it is always black. How may I make it display
blue (or any other color) in datasheet view? I have
temporarily set conditional formatting for the data
condition 1=1 sets font to blue. This works, but seems
dorky. Please help.
 
I am displaying data in a form in datasheet view. In
design mode I have set the font color to blue. But when
displayed it is always black. How may I make it display
blue (or any other color) in datasheet view? I have
temporarily set conditional formatting for the data
condition 1=1 sets font to blue. This works, but seems
dorky. Please help.
Click to expand...

If you're not doing conditional formatting, but want to display all
the records in a particular Font color, open the Form in Datasheet
View.
Click on Format + Font.
Set the font color for all the records.
Save the changes.

If you have Access 2000 or newer, you can still use Conditional
Formatting to change individual fields that meet your criteria.
 
Back
Top