Does the background color on subforms can be changed to transparent?I have a form which contains 4 subforms. The main form has a picture that likes up with the 4 subforms, but when i go to make the sub form background color transparent it is greyed out.
View RepliesI have some tab controls, which for some reason show up white.
I have set their back style to transparent but it doesn't seem to show the grey Windows colour of the background form.
Any ideas why ?
AT the moment I'm having to put grey rectangles in various places to cover this up, which is obviously not ideal.
I would like to have a Positive value with a green Background and a Negative Value with a Pink Background.
View 3 Replies View RelatedI have a question related to a textbox on a form.
In my table (tbl_data) I have a field named Rating. This can be anything from 1 - 10.
On my form (frm_input) I have a textbox (created using the wizard so at the moment I'll call it txt_Rating).
What I would like to know how to do is:
If the value in the textbox is 0-5 leave the background colour of the textbox white with black font.
If the value in the textbox is 6-7 turn the background colour pale yellow with black font.
If the value in the textbox is greater than 7.1 turn the background colour Red with white font.
I have a listbox and whenever I clicked on a row it will highlight black background and white font color. How can I disable this or change the formatting?
View 2 Replies View RelatedIn Access 2007 (or 2010 , 2013), in a continuous form, I want to change the background colour of a text box depending on its value. Obviously, for each record, the color can be different.
View 1 Replies View RelatedI would like to change the Font and background color based on dates.
-I have a text box (Training Event) on a form populated from a field (Training Dates) in a query.
- I need the font and/or the background in that text box to change to red when the date is 12 month past, yellow 11 months past, white 10 months past and green for 9 months past.
I am using a continuous form and would like my users to be able to change a field background color to a light red by double-clicking. The user would also be able to change it back to white by double-clicking again.
The code I am using (below) changes the field background color for all records. I need my code to only change the field color of the current record and cannot seem to find how to do that. The field name is [System_CurrentStatus].
Private Sub System_CurrentStatus_DblClick(Cancel As Integer)
If Me.System_CurrentStatus.Backcolor = vbWhite Then
Me.System_CurrentStatus.Backcolor = RGB(234, 154, 160)
ElseIf Me.System_CurrentStatus.Backcolor = RGB(234, 154, 160) Then
Me.System_CurrentStatus.Backcolor = vbwhite
End If
End Sub
in a continuous form i want to click on one record and have the one field change the background colour to highlight it. When I use the code: Field. BackColor = vbYellow it changes the background on all the records. Is there a code to say only for the record with focus?
View 1 Replies View Relatedhi every one
i have an application and the user was asking me to give him the ability to change the backcolor of the main form
i had done that with one color option.
but now he wants to mix two colors together
any one can help me with that , if code or sample would be posted, that would be appreciated .
thanks in advance
How do I change the background color of a tab or can you? The form that I am looking at has a tab button, but it looks like a normal form for the background. It has the grid and has a color for the background. I have designed a new form and added a tab control. But the background is grey and I would like to change it. Please help, if you can. Thanks.
View 1 Replies View Relatedhttp://i54.photobucket.com/albums/g115/TomBP/changecolor.jpg
I want to change the background color to a plain white color. So I used the coloring bucket to fill it in. The problem is that it does not have any effect. In the picture you can see that the greyish color with the white dots remain.
This is some kind of standard template. Is there anyway I can remove it so I can fill in plain colors?
I have a Data Access Page that I need some help with some of the code.
I need to do a comparison to see if the TimeStamp Control is less than one hour old. If it is, it should have the background turn red. If not it should stay white.
Form = BLine_Messaging
Control = TimeStamp
Code:<SCRIPT language=vbscript event=onload or=window><!--If (BLine_Messaging.TimeStamp.value > DateAdd("H", -1, Date)) THEN BLine_Messaging.style.backgroundColor="white"else BLine_Messaging.style.backgroundColor="red"end if --></SCRIPT>
I have installed Windows 10 & Office 13.The Background color of MS Access 13 is white in color which is irritating. Is there a way to change the background color?
View 7 Replies View Related:confused: <b>Hi all, can Access highlight the selected rows in table just like the spreadsheet in Excel??
Many thanks,
When I set the background color of a "rectangular box" to Normal (not transparaent), there are some fields that do not display - they are hidden behind the box. If I move the box, delete the hidden fields and add them back in, they appear fine. Is there a way to set the box color to allow all fields appear in front without having to delete and re-add all fields?
Thanks,
SKK
Hi,
I have design a form using the tab control. I need to add in color to make it more professional. Is there a way I can do it. I realised the filled /Back color icon is faded in color in design view.
Appreciate any help in this. Thanks.
In an effort to refine the looks of my database, I was wondering if anyone could tell me a way of setting the Background Color of a control to Translucent, i.e. Textbox, Label, or Rectangle.
I want it to be partially transparent so I could then overlay it on top of an imported picture. I would then place the description of the photo on top of this translucent overlay.
Another possible solution may be to use an image as the background if someone knows how to make an imported image translucent.
So far as I can see, my only options in Access are tranparent or opaque. Any way to do something programmatically
Any thoughts would be great,
Thanks,
Scott
I don't want to get fancy with changing the colour of tab controls (a la S. Lebans), I'd just like to be able to duplicate the default gray color. Does anyone know the numeric expression to enter in the tab control's Background Color box?
Many thanks.
Does anyone know/how my forms' background colors are different from one computer to another? The computers that are showing the correct color are both XP and Access 2002 (one is a laptop and one is a desktop)... but then someone else.. on a laptop (with XP and access 2002).. the forms' background colors are not good (purple)... vs. blue on my laptop and the desktop. Thanks!
View 3 Replies View RelatedI need to change the background colour of a text box after a change to the field has been made?
ie.
Make: IBM (Background Color Grey - Default)
User makes a change to Make ..
Make: Toshiba - (Background Color changes to Yellow )
I'm trying to code this with the OnChange option on the TextBox but can't see to find the right code.
I was using Application.SetOption"Background", colour value with no success
I searched around but i couldnt really find or atleast understand how to do what i want to do. I want upon the user clicking on a checkbox for the background of the form to change to a set color?
View 8 Replies View RelatedI'm trying to create a report that has certain rows filled with a background color. In excel, the fill color is complete across the row. That is, there are no gaps between cells. In Access, each individual "cell" or field is filled with the color but inbetween each cell/field there is white space. I tried changing the control padding to "narrow" but there is still too much white space. Changing control padding to "none" changes the alignment of the cells to look off. They aren't exactly lined up in a row anymore. It looks terrible.
View 2 Replies View RelatedI'm using the changebackgroundcolor.zip sample that I found here at Lebans site. URL....I'm trying to find a way to keep the color that I picked after the database closes. I tried to follow the example here URL....but couldn't get it to work.how to get the color to stay on the color that was picked from the dialog box?
View 1 Replies View RelatedI have some code to check a combo box if a date field is filled in, then the combo box can't be empty.I can make the error message appear, but the combo box does not want to change color and it does not recognize any other than value..This is the code that I have, and it does not work like I wish it could.(I took the database over from some one else and need to make improvements on it. the field names where not created by me).
Code:
Private Sub cmbCurrentStatus_AfterUpdate() '<<<<<<<<<<<<<<<< Working on >>>>>>>>>>>>>
If IsNull(Me.[STEP 1 4 check current status]) And Not IsNull(Me.[Checked__date_]) Then
MsgBox "Checked (date) can't be empty if Current Status is filled in!", , "Incomplete Form!"
Me.[STEP 1 4 check current status].Value = RGB(255, 0, 0)
Else
Me.[STEP 1 4 check current status].BackColor = RGB(255, 255, 255)
End If
End Sub
I have a report. In this report I have a start date and an end date. I also have a date that is going to be checked. The report checks to see if the date the user entered on a different form is between the start and end date of an individual. if it is, a txt box at the end of the line will turn red. If it isn't the box will stay default of green.
What I would like to do is not even show the lines that have a green box. I want to just show the lines that have boxes as red.
I looked into If statements but I'm not quite sure what event I should put them on, nor am I certain I have the syntax right.
I had it:
If (lblAvailability.BackColor = "#CCB13D" Then
txt1.Visible = False
and so on... making all the txt fields invisible. I would rather have them not even show up because I'm pretty sure invisible things still take up room.
End If