Tab Form Wrong Colour
Feb 25, 2006I open my form in design view.
Click tab control to place a tabbed form.
The background colour is a different gray and the tabs are white.. i just want them to be the default colour...
ADVERTISEMENT
Form Navigation Button Bar Colour
Jul 26, 2005Hi,
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).
TIA.
Change The Font Colour For The Whole Form?
Jan 17, 2006I've been working on a database for quite a while now, and i've now given it out for testing, and i've come across a little problem. One of the users is colour blind, and the colour theme i've used throughout this database is causing him problems.
I have a function that can single him out when he logs in, question is, is there a way i can change the font colour for the whole database in one go through code??
I have around 12 forms with many controls and labels, i'm kind of hoping i don't have to name each control and label separately to change the font colour.
Please tell me that there’s some clever piece of code that can change the font colour on a form in one hit…..
Regards
Darren.
Form Details Colour Control
Jan 2, 2007Hi,
I have a couple of identical databases in Access 97, they have lots of forms. My users use the two different versions of this database, but linked to different sets of data depending on what they are doing.
I distinguish between the two versions by making the background colour of the log on and Switchboard forms different. It would be nice if I could cause the background colour of the other forms to match the Switchboard without having to go through and change each form individually.
Can someone please give me a clue as to how this can be done?
I know using Me.Detail.BackColor = RGB(100, 100, 255) would work, but I can't see how to a) get the RGB values from the Switchboard.
Regards,
Bernard D
Forms :: Change Textbox Background Colour Pending Value Of Two Textboxes On Form?
Jul 9, 2013I 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.
View 4 Replies View RelatedWrong Form Dimensions
Feb 16, 2006I have create a form with specific dimensions whowever when I view it it is larger than it should be.
Whats wrong?
Form Opens To Wrong Record
Sep 21, 2006I have a form based on a query. The query sorts records by ID number. When I open the form, it opens to a record that is not the lowest ID number. It's the same record each time that it opens to, but it's not the correct record There is no filter or sort order on the form, and it seems like starting with record 2 it is sorting correctly. any ideas? thanks.
View 1 Replies View RelatedWrong Box On Form Attached To Wheel Ball
Feb 1, 2005I have one form which is created from one table.
I open the form and if i scroll with the mouse it doesnt move through records, it stays on the first record but amends the details for that record in the second box.
any idea how i can set the scroll mouse function to browse through the records rather than the project box, which amends which project that record is ascoiated with.
Thanks
Switchboard Opens Form In Wrong View
Feb 8, 2005I have designed a form which I want the users to see in Datasheet form.
In the properties, "Default view" is "datasheet" and "Views Allowed" is "datasheet"
When I open it directly, it opens as a datasheet.
But when the Switchboard opens it, it comes up as a Single Form. Infuriating !
What to do ?
NoVoiceLeft
Currency Field In Form - Updating Wrong
Aug 12, 2013I have a question about entering in currency on a field in one of my forms in my DB.
Essentially the problem I'm having is this: Upon entering a dollar amount, for example say I want to add $350,621.
It shows up like this: $35,062,1
That happens because it is filling in left to right when I tab down to the field, but if it fills in right to left I'm sure it'll fill properly.
General :: Form Starting At Wrong Position Of A Page
May 9, 2013I am a newbie to ms access and forms and I have a small problem with a form. The solution has lots of different forms with different tabs for each section. This particular tab has a few sub forms in it. When I switch into the specific tab in question, the screen moves down ever so slightly and I always have to scroll up to see all the other tab headings.Is there a way to do something by code or a property setting I can use to make the page start from the top without users having to scroll up each time?
I hope I have explained myself clearly enough, if not I will be more than happy to provide more info.
Wrong Record Selected From Macro Of Open Form Button
May 1, 2012I have a parent form showing some of the contents of a single record in a parent table. This form contains a button that opens a specific subform (using an IF statement based on the contents of another field in the parent table/form. There are actually any of 8 child forms/tables that could be selected and the related record is in only one of them. The relation between the tables is based on the PK of the parent table and the related FK in the child table. and the data is correct in all tables.
My problem is that when I run this button on the parent form/table it returns the appropriate form/table, but displays the first record rather than the related record. In the past (using this same process) I have been successful in getting to the right record by fiddling with the where statement (sometimes putting in a equal sign or taking it out fixes the problem). However, no matter what I do to the Where statement nothing works. I have not yet placed the final else condition for where the form selection field (VMValIdentType] is empty yet as there is no point at this time.
Here are the button macro contents:
If [VMValIdentType] = "Software"
OpenForm
Form Name: tmpVMValSW
View: Form
Filter Name:
[code]...
Font Type In Form Changes When Change Font Colour
Aug 1, 2014I am experiencing a problem in MS Access 2013. I have a form which was working just fine until now. It has form labels in Calibri font and their font colour is one shade lighter than black. Today, I changed the font colour of the form labels to be Automatic - black (shows as 'Text 1' colour in the form properties). I did this in Design view.
I find that when I switch to layout view, the font of the labels appears as Century Gothic. This is the font that appears in the Form view. So while the font colour is correctly changed, the font name is not what I had set in the Design view. When I go back to the Design view, and change the font colour back to the original colour which was one shade lighter than black (Text 1, Lighter 50%), the font is correct in the Layout view and the Form view (Calibri).
So it seems that there is some sort of binding between the font colour (black) and the font name (Century Gothic). When I change the font colour, the font also changes. When I restore the original colour (one shade lighter than black), the font Calibri is correctly retained.
Using Colour
Oct 22, 2005Can anyone advise how I can get access to change the colour of data or cells , so that when I print out cells or data is coloured
View 1 Replies View RelatedColour
Aug 1, 2007Is there anyway of putting colour onto table headings to divide them up and clearly show which headings are for different categories?
Thanks, Steve
Tab Colour
May 24, 2006I 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?
Colour Pallette
Sep 13, 2005Hi, 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?
View 1 Replies View RelatedColour Picker
Jan 31, 2006Im 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!
View 2 Replies View RelatedTab Background Colour
Apr 26, 2006This 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.:(
View 3 Replies View RelatedBackground Colour
Oct 18, 2006Hi
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
Each Alternate Record A Different Colour?
Aug 7, 2006Hi,
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.
Anyone give me a starter on this one please?
Thank you
David Williams
Colour Printing From Report
Jan 17, 2007Hi 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.
Change Background Colour !
Jan 24, 2007Hi,
I'm currently using MS Access 2002.
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.
Kinds Regards
Chris
Tab Control Background Colour
Apr 17, 2007Hi all,
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.
Any ideas?
Cheers,
Rob
Page Colour Name Change
Apr 25, 2005page colour name change
View 3 Replies View RelatedChange Label Colour
Nov 3, 2006Ok 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.
Thanks in advance
http://img101.imageshack.us/img101/223/switchsamplert7.jpg