473,883 Members | 3,034 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Changing Form back color in Datasheet view - Access 2007

44 New Member
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.
Jan 27 '13
13 17491
32,584 Recognized Expert Moderator MVP
Indeed Smiley. That about sums it up.

Z. That's fantastic to know. Adding the property is not a problem. I just never knew it even could be until your comment.
Jan 30 '13 #11
5,501 Recognized Expert Moderator Expert
Ran across it quite by accident.
One of the commercial applications we were using could do this... so trying to duplicate it... thinking that the COM add-in had it buried, well, leave it to a chemist to break something apart (giggle).
Jan 30 '13 #12
2,322 Recognized Expert Moderator Top Contributor
/me runs off to google "Access easteregg" and "Access hidden features"
Jan 30 '13 #13
32,584 Recognized Expert Moderator MVP
leave it to a chemist to break something apart (giggle).
I'm continually impressed by the chemists we have contributing on the site :-)
Jan 31 '13 #14

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Kent Eilers | last post by:
I want to follow naming conventions for my controls - i usually prefix combo boxes with "cbo". When a form is in datasheet view however i do not want the user to see the 'cbo' prefix in front of the field name. Is there a way to retain this nomenclature and yet have the view display the field name (or anyname i want for that matter)? Thanks --
by: Georges Heinesch | last post by:
Hi: I have a tables in relationship to each other. When I open the main table (table 1), I see a "+" at the very left of every record. Clicking on the "+" expands the data of the linked table (table 2). Now ... when I create a form from table 1, I didn't manage show these 2 tables the same way (with the "+" at the left side of every record) as it was shown as table. Access insists of making a regular form out of table 1, but accepts...
by: sierrachang | last post by:
Why would one not want to sort records in a form using Form Properties > Datasheet View > Sort Ascending? It's the fastest way, isn't it?
by: Nilz | last post by:
Hi all, i am using UltraWinGrid in my application and i want to change the Back Color of the Active Cell to transparent. i have defined CellClickAction as RowSelect. So if we click on the cell the row should be selected and the cell which was clicked must be de-selected. If anyone know anything, plz help me out. ___ Newsgroups brought to you courtesy of www.dotnetjohn.com
by: gnews | last post by:
I'm learning Access (2002) as I go, but I can't find how to open a form from a datasheet view. I want to be able to view records in the datasheet and click on a link to open a form to allow me to update the particular record I was viewing. I've been experimenting with hyperlinks but fear I may be barking up the wrong tree. Any help appreciated.
by: guroos | last post by:
If there are no custom toolbars in 2007 runtime how do I enable a user to switch to datasheet view and back?
by: dwasbig9 | last post by:
Hi Group, I'm creating a maintenance switchboard and am trying to create forms to update tables and wanted these to appear as datasheets. Although I have the default view set to datasheet and when opened directly the form opens in datasheet view, as soon as I try to open the same form from the mainenance switchboard it opens in single form view. I'm using Access 2000. Sorry if its a basic error on my part but cant see what I've...
by: gman | last post by:
Is there a way in VB.NET to build a Form/Control as easily as Access 2007 does? I built a small name and address application in Access 2007 and I was surprised at what I was able to do without any code. Access Forms allow a Datasheet (GridView) to show by setting a property (I have mine set to Datasheet on Top). Pretty sweet and easy. I am a seasoned programmer (over 20 years) but I am a newbie to VB.NET 2005. Our company brought in some...
by: phillikl | last post by:
Good day, First would like to say I use this site to find more trivial stuff than anyplace else.. THANKS!!! Been looking for a few hours on this and seem to be not asking the correct question. I am attempting to build some "Strategic Planning" software and my boss would like to see a tree or heiarchial structure: Example: 1. Pet Products (category)
by: GARZAAX | last post by:
Hello; I am in serious need of help. I have a form with subform that I am developing to fill in multiple data on customer orders. the need has come to duplicate up to 10 times the information on the Form and Subform with just the orderID changing. I tried append query with no success because my MS Access program will not recognise the !. line as valid, so i cannot wright to the Tag property. I am now using the SQL statement If...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.