Access information

[Guest]

When I change one piece of date to a different color, all information in the
database changes to that color. How can I single out individual pieces of
information for different colors?

 

[Joseph Meehan]

When I change one piece of date to a different color, all information in
the
database changes to that color. How can I single out individual pieces of
information for different colors?

I would guess you could do it in VBA (programming language), but I don't
believe that there is any built in way of doing it. Unlike Word Access
seems to apply font information to fields not individual letters.

BTW where do you want to change it? In a Table, Query, Form, or Report?

If you want to display just say the day of the month in a different
color like January 23, 1986 and you wanted the 23 to be in a different
color, on a form or report, that might not be too bad. You would make three
fields all based on the same data with the first displaying just the month
the next the day of the month and the last just the year.

 

[Van T. Dinh]

You will need to tell us where you want to change the display.

DatasheetView of Table / Query? A single Control on Form? Continuous Form?
Subform?

Describe in details whay you have now and what you are trying to achive.