This should be an easy one for somebody. I'm a newbie to access and I'm experimenting with a tabbed form. My problem is if I create a new form with (say) two tabs, the area to the right of the tabs(where more tabs would be inserted) is white and I don't know how to change it to blend in with the rest of the page. Hope I'm making myself clear.:(
Hi We have created some forms using (in some cases) the form wizard. As you may know you have to select a "Background Style" when using the wizard. Now we want to change the background from one of these styles to a colour - but when we select it in Properties and try to apply it, it seems to flicker but does not seem to have any effect. Can anybody help us out please ? many thanks ajm
I use forms to display client info and i would like to know if the following is possible, and if so, how ?
When a clients installation date is older than 6months old (date is in a text box) i would like the form's background to change colour for that paticular client.
eg/ if the clients installation date was 7 months ago, the form's background would change red - but only to that client.
I have been searching for a setting that enables me to change the background colour of a tab control on a form. It may be something obvious that I have missed.
Changing the type to 'transparent' and setting the form background colour does not seem to work.
I'm opening a form in snapshot view and would like the background colour of all the fields in the form to be a dark colour to show that it is in snapshot. the user then clicks Amend and the background colour would change to something lighter to show they can amend the record. Is there any way of on the OnClick event of the Amend button change all the fields (and there's lots) at once without having to name them all individually, ie:
Something that's been bothering me. I have a unbound subform which acts as a placeholder for other subforms rotating on it (by changing the SourceObject), that way all the relevant subforms appear in the right place when required. It works great except, it's this great big white box and there's no option to change the background colour anywhere. I would like it to be either transparent or have an option to change it to the same colour as my main form it sits on.
Im trying to change the background colour of some fields if the value is null or missing, but I'm not quite sure how to handle the coding. The fields in question are title, given name and surname, and if they are empty I want to change the background colour to highlight to users that they need to collect this information. Any help that you can provide would be great!
I have a form with subform that uses colour as background colour for all fields on the form, and also a very light background for the whole form. This outputs very well to PDF, retaining all of the layout etc.
However, consisting of over 100 pages I do not want any colour at all in the printed report, no do I want the colour converted to black or grey. Inkjet cartridges are just too expensive!
Is there an easy way to remove all colour before printing or do I have to design another report?
Here, what I am trying to learn, that background of the form change its colour automatically after sometime let say 1 min or after 2 min
I find the link on the web where more than 500 colour code are available, but not sure, how I can use [URL] ....
I can put this command on form_load() Me.Detail.BackColor = ????????? but question is how i can bring other colour into loop
Plus, if the user want to do any work on the same form, will this loop also allow the user to do any work, I mean form should not be stuck up in the loop of changing a colour...
I have a form with two textboxes that get their values from two different queries that counts records from table. If textbox1.value equals texbox2.value the textbox2.value back ground colour is green. If they are not equal textbox2.value goes red. Itried with using conditional formatting, but it doesn't work all the time as the form is not updating when it is opened.
I have checked the forum for tab colour/color and there is plenty telling me the background colour of the tab control but I couldnt find a single thread on the actual colour of the tab - you know (in Access 2003 anyway), that sort of off white colour. I have put a subform onto one tab but I cant get the background colour of the form to match the off-white colour of the tab.
Does anyone know the RGB or Access number for this off white tab color?
Hi, I have a text box on a form that I want to link to a colour pallette. I want it so that when a user clicks in the box, the colour pallette appears, the user then selects a colour rom the pallette and the text box turns that colour. I'm sure ive seen example of this sort of thing but I cant find them. Any ideas anyone?
Im using a colour picker to change the colour of a text box on click. I need to store the colour in the text box. At the moment it changes the colour of the text box in every record. How can I overcome this? Thanks!
I am trying to produce either a report or a form that displays records 1 to a line. That bits easy enough using a tabular layout. I would like to make text boxes that hold the data a differnt colour on each alternate line. So the background colour changes from white, then green, white , green etc.
Hi all, i'm having a rather annoying problem. When I view my report I have 2 sets of conditional formatting that run, one that changes the back colours of certain fileds when the criteria is meet, and the second, the text colour of certain fields, both of which work fine when previewing the report. However, when I print the report, any of the back colour in the preview does not print out but text colour does. If I print from another office programme i.e. Word, block colour is printed fine its just seems to not work in my access.
Please note that if the same report is printed from another computer, it prints fine.
Please does anyone have any idea on why this is happening and how to sort it. Thanks in advance for any ideas and help.
Ok what I would like to do is have a switchboard with a number of command buttons on, each button opens to a form with a few fields within them.
Is it possible for the initial switchboard labels to be 'red', then as the related form is opened and populated the switchboard label turns 'amber' and once the form is complete the switchboard label is 'green'. See example piccie attached, to get a better understanding!
This is to enable multiple users to see at a glance the status of various jobs.
If anyone knows how I can go about this or suggest any alternatives, I'm open to suggestion.
Right, I recently created a hex colour chooser using 3 ActiveX slider controls. It's kinda interesting, and should provide a good starting point for anyone interested in changing the bqackground or foreground colours of text boxes a good idea of what to do as well.
It was created as part of a simple database that could change the menu items in an asp page, what they linked to, and what colour they would switch to when the mouse hovered over them (looked like the old magic buttons, but was really just a div changing colours in a table, and the div had the hand cursor though css, so it was hard to believe that it was only text)... I can post that code somewhere too if you guys want, works in IE and Mozilla.
Beyond the colour chooser, it also had an open dialog which would create the Reletive URL from the databases location if it was in or beyond that directory. It did some stuff with file input and used the copy API too if anyone wants me to post the whole thing my employer says I can keep all the database code and objects I create so long as I delete any sensitive data.
The coolest part is the colour picker though, which I have posted here
To use it, just do a DoCmd.OpenForm. If you pass it an OpenArgs value that is a hex string (as you would see in a website, so #RRGGBB) then it will start out at that colour, and restore to it as well with the return to original colour button. You should open it up as a dialog really, then check the global variable strColourChosen (declared in the module)
It requires the two functions in the module, the ChangeToHex and ChangeFromHex, to work, and it also requires the global variable strColourChosen.
If you think this is a garbage post, tell me and I'll avoid making them in the future.
I have a sub form on a tab control and would like it (the form) to be the same colour as the tab control... what colour should I set the background to?!
Ive got it nearly the same colour after quite some time, however it would be good if it was the same.
Is there a way to totally remove the navigation button bar? Even though setting form navigation buttons to "No" removes the buttons, the "bar that held the buttons" remains in it's default gray colour. I'm trying to make a subform blend in with the main form but this is posing to be a problem because of the old remains of the navigation "bar" (See attached image to see what I mean).
HI all, the objective is to grey out an item within a listbox, where the id number is the same in another sub form. The sub form is called contacts and the list is called list15. the unique id that is linking the two is SWD.