A very simple YES/NO question.

[Noreene Patrick]

Someone asked if you could change the color of a table name....I couldnt find any way to do that....Is there a way?

Thanks, NOreene

 

[The_Doc_Man]

Change it where? In the table pane of the Access window? That is governed by the Windows color scheme and your choice of list / icons / details. Believe it or not, Access doesn't really control that.

 

[Noreene Patrick]

yes, in the table pane of the Access window...I felt like it couldnt be changed the same way as Excel and Word because there was no format option.

Thanks Doc Man.

 

[The_Doc_Man]

By way of amplification, Access defaults to using your Windows color scheme, and when you are showing the Tables, Queries, Forms, Pages, Reports, Macros, or Modules panes of Access itself, your code isn't running. Which is the "why" of why you can't do that.

When an actual form or report is being displayed, printed, etc., your code IS running (or your data structures are displayed, same difference), so you get to control that.

 

[Anthony George]

You could use a form in datasheet view

Hi

1. Create a form based on the table using the wizard
2. open the form in datasheet view (DoCmd.OpenForm "Yourform", acFormDS
3. Click Format on the Toolbar to format Font, Datasheet, colours etc.
Hope this helps

Tony