在数据表视图中更改表格返回颜色 - Access 2007 [英] Changing Form back color in Datasheet view - Access 2007

问题描述

我有一些从查询创建的表单，并在数据表视图中显示。我可以在设计模式下更改背景颜色，但是当我保存更改并打开表单时，它们会再次恢复为旧的灰色。是否有一些VBA代码我可以用来设置每次打开表单时的颜色？到目前为止我没有成功。

I have some Forms that were created from Queries and are presented in Datasheet view. I can change the back colour in design mode but when I save changes and open the Forms they revert to the old grey color again. Is there some VBA code I can use to set the colour every time a form is opened? I''ve had no success so far.

推荐答案

数据表视图的颜色与单个表格无关。数据表视图及其配置是Access本身的属性，您可以使用工具 |进行配置。 选项并选择数据表标签。

The colour for Datasheet View is not relative to individual forms. Datasheet View, and its configuration, is a property of Access itself, and you will find configuring it can be done using Tools | Options and selecting the Datasheet tab.

我相信在Access 2007中，这可以在文件中找到（Office徽标） >访问选项。但是，在Access 2010中，数据表选项卡中没有背景颜色选项。不确定Access 2007是否包含它。

I believe that in Access 2007, this would be found in File (the Office logo) > Access Options. In Access 2010 however, there isn''t an option for the background color in the Datasheet tab. Not sure if Access 2007 has it there or not.

谢谢你们。这个数据库有很多表单。一些是从查询转换而来主要是为了使它们可编程，但也能够使它们直观地识别（或者我认为）。我想知道在表单加载时使用VBA中的BackColor属性是否可以实现这一点，但是你的回复意味着没有。无论如何，谢谢。

Thanks guys. This database has quite a few Forms. Some are converted from Queries primarily to make them programmable, but also to be able to make them intuitively recognisable (or so I thought). I wondered if this might be achievable using the BackColor property in VBA on Form loading, but your replies imply not. Thanks anyway.

这篇关于在数据表视图中更改表格返回颜色 - Access 2007的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！