Forms :: Set Default Alternate Row Color
Jul 29, 2015
Is there a way to permanently set the alternate row color in access, so that whenever you create a form it will always be what I want.I know that I can make a template and always use the template, but I would prefer to just change the access settings if that is an option.I checked the access settings but couldn't see an option to do this.Also if you can set sub-form's to always have a transparent border, so that you don't have to change it every time you add a sub-form to a form.
View Replies
ADVERTISEMENT
Feb 14, 2012
how to set the default in Access 2010 so that alternate row colors do not display when you create a new table, query or report.
View 3 Replies
View Related
Oct 25, 2005
Hello,
Does anyone know how to color alternate rows in two different colors in a continuous form?
:(
View 1 Replies
View Related
Sep 25, 2013
This is re-statement for clarity of earlier thread deleted.
In Access 2010 I have a Report with a Detail Section that shows a record and a Sub-report that shows the many records of a one-to-many relationship.
The Report Detail Section Property Sheet specifies a Back Color and a different Alternate Back Color.
Report View alternates the Detail Section background colors correctly.
Print View and Printing DO NOT correctly alternate the background colors. Back color and Alternate Back Color appear in irregular sequences.
how to fix it?
View 2 Replies
View Related
Jun 9, 2014
Using Access 10 I am unable to turn off the alternate row color function for my report. The icon is on the toolbar, but is grayed out so I am unable to select it.
View 1 Replies
View Related
Sep 5, 2014
Where can I find the Hex or RGB value for the blue colour that Access 2010 uses by default for buttons on forms? I need to change some buttons to yellow (I know the code for that) but later change them back to the previous shade of blue, which is shown in the Properties pane "Accent 1, Lighter 40%".
By clicking in the standard colors area at the bottom of the colour chooser I can find a very similar blue #D6DFEC but it doesn't look quite right. And the "accent" colour does not give me a Hex value.Is that "usual" blue even one colour? How can I reset a button to that style having changed it?
View 14 Replies
View Related
Jul 4, 2013
I have a sub form in datasheet view and need to custom alternate row colors with criteria from the main form.
E.g. If the Criteria field in the main form is 4, row colors must alternate after every forth record in the sub form. First 4 rows not shaded, next 4 rows shaded. If the Criteria changes to 6 then first 6 rows not shaded, next 6 shaded etc. I can do this in a Report with the Format Event but in a Form there is no Format Event.
On the Home tab, under Text Formatting group, using the Alternate Row Color drop-down list, changes every row, which is not what I need.
View 1 Replies
View Related
Nov 1, 2013
We use access to enter our service tickets in at work.What we have are three date fields.
Call Date
Start Date
End Date
We are 24/7 operation.Currently all 3 just autopopulate with the current date.What i would like to do is ADD a CHECKBOX next to each Date Field.And make it work like this.
1. let them autopopulate as they are currently
2. if you end the call AFTER MIDNIGHT (the next day). CHECKING the box would automatically populate yesterdays date in each of the fields that has the check box CHECKED
View 3 Replies
View Related
Aug 7, 2006
Hi,
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
View 4 Replies
View Related
Aug 30, 2004
I have 3 unique numbers that can identify a specific customer. I would like to my form to locate a specific customer by using whichever parameter the customer can find. Is putting 3 seperate queries on the form the best way to acomplish this?
View 1 Replies
View Related
Oct 28, 2013
I'm new to VBA - Access but just dangerous enough to get in trouble. Is there a way to make a variable with the code below? I've been scouring the net all day and can't find answer. What I would like to do is make all the "cirsize1" be a string. Particularly the "Me.cirsize1.ForeColor". if I use the "cs" string it works fine with the Me.cirsize1 = 0 (ie "If cs = 0") This is just a snippet of the code.
Private Sub cirqty1_AfterUpdate()
Dim cs As String
cs = Me.cirsize1
If Me.cirqty1 > 0 Then 'if there is a quantity greater than 0 in circle qty and
If Me.cirsize1 = 0 Then 'if there is 0 in circle size
Me.cirsize1.ForeColor = vbRed 'then make the circle size 0 red
Me.txtCirIPM1 = 0
End If
End If
End Sub
View 14 Replies
View Related
Aug 2, 2013
I created a form that has about 200 fields and all the fields are utilized at a point depending on the work order assigned to us. I wanted to know if it's possible to put like a toggle box or a check box etc. next to the field so if it is checked it would be in a Dark color and the ones not utilized are in a shade of gray. All the fields are coming from the same table. Another thing it's an estimate worksheet so a row would have something like, Labor, QTY, HRs, Overtime, total as columns, so I would want a check box to have control over those but one for each row, EX contractor, locksmith.
View 3 Replies
View Related
Jan 14, 2015
I have just noticed that one of my forms (memo field) with copied text from internet has lots of different color letters when the text is highlighted.
View 2 Replies
View Related
Aug 2, 2012
I have a table with an ID and PartNumber field.
Parts tbl
PartNumID PK(Auto)
PartNumber
Heres some example data:
1 M24308/2-2F
2 M24308/4-2F
3 ORD9F0000
4 ORD9M0000
5 D90000VLO
6 D90000JOO
How would I design the table to allow me to define alternatepart numbers and also related parts? For example:
Record 1 is the primary part and record 3 is the alternatepart.
Record 2 is the primary part and record 4 is the alternatepart.
Records 5 and 6 are related parts to records 1, 2, 3 and 4.
I have a form that allows the user to select a part and displaythe part data. But I also want the alternate parts and related parts displayedon the form, maybe in a subform with tabs. I havent gotten there yet because Icant determine the table design.
View 3 Replies
View Related
Jul 1, 2015
I am using the Desktop Project Management template in Access and want to change a Open Project query from displaying the "id" which is a number, to the name column. In the projects table the field is set to number which is in a relationship with the employees table. Without changing any of that is there a way to run a query that will display the name instead of the number?
View 6 Replies
View Related
Oct 10, 2013
Not sure if this is can be done: I have a picture and I want to change its color in accordance with values in another textBox. Is that possible? if Yes, then what would be the procedure and the codes?
View 1 Replies
View Related
Jul 2, 2013
I can use Conditional Formatting on the text to color code the record data in a report.But, I want the text to be the same color.What I'm trying to do is add a Box control from the Design Tools and color code the box depending on the value of a field in the table. The box will appear next to the record.
The field is called ReminderTypeID and there can be only two values for this field - 1 or 2.If the value is 1 I want the box's BackColor to be red. Otherwise what ever color I assign it to in design view.I've tried the following in the On Current.
Code:
If Me!ReminderTypeID = 1 Then
Me.bxCode.BackColor = RGB(186, 20, 25)
End If
I get no error messages but in all records bxCode has the same color which isn't the one I'm trying to set.
View 5 Replies
View Related
Oct 18, 2013
I have a subform that is purely to display information (no edits will be made on it). The subform has a special color on it (company color) that I can not deviate from. My problem is the first record in the subform (displayed as a continuous form) gets the focus. The font is white and standard access has a white background. My end goal would be to elimnate the focus for any record in the subform (if it is possible). I know that I could change the color with conditional formatting but the colors in conditional formatting do not match the company color.
View 4 Replies
View Related
Apr 16, 2014
I would like to have a conditional formating colour of green if the field contains a value like 10%..If the field has no value and is blank there will not be any background color change
View 1 Replies
View Related
Apr 21, 2013
I have several forms that each has a dozen or more checkboxes, true/false. I want to be able to change the background color of the label of each checkbox depending on if the checkbox is true or false. I have used the following code which works great:
If Me.A = True Then
Me.lblA.BackColor = vbYellow
Me.lblA.BackStyle = 1
Me.lblA.ForeColor = vbRed
Else
Me.lblA.BackColor = vbWhite
Me.lblA.ForeColor = vbBlack
End If
Me.A refers to T/F checkbox A and Me.lblA refers to its label. This is repeated for each of the checkbox controls. If the control is [B], then its label is lblB. I have used this in the form OnCurrent event and the checkbox control OnUpdate event. I was wondering if I could use the tag property to this, saving me writing countless lines of code and having the OnCurrent event of each of the forms so long and cumbersome. And I do know that I can use conditional formatting to do this, but I would prefer not to use that method. Is there any way to do this using the tag property and not so many lines of code?
View 7 Replies
View Related
Aug 14, 2015
I have three labels that I can't change the text color. I must have them locked or something. What should I check?
View 5 Replies
View Related
Jan 9, 2014
Using Access 2010. I have a form on which I've placed a simple label. I try to set the label border color to black but it shows grey. I can set the border color to #000000 and it's grey. I set it to #000001 and it shows black as expected.
I'm thinking it has something to do with the themes, but shouldn't an exact color code show as expected? As a new member (<10 posts) I can't post an actual link, but here's the text of the location: [URL] ....
View 2 Replies
View Related
Sep 24, 2013
I have this code that should change backgroundcolor in multiple items form based on a value of a field:
Private Sub Form_Current()
'check if field on form called somefield is DVD
If Me.TYPE.Value = "DVD" Then
Detail.BackColor = vbRed 'DVD
Else
Detail.BackColor = 16777215 'BOOK
End If
End Sub
But it does not work, what can I do?
View 1 Replies
View Related
Sep 19, 2006
Hi,
Is it possible to display records in different colours in a list? e.g. 2 colours: first line will be colour 1. Second line will be colour 2. third line will be colour 1...etc
Regards,
B
View 6 Replies
View Related
Dec 6, 2006
Dear All:
I have a report in Access 2000 showing names, ID numbers, Address and dates.
I wish to have alternate colors instead of the default white backgroud Access has.
Any ideas on how to start?
Many thanks,
Dion
View 2 Replies
View Related
Aug 13, 2014
I have a query expression that calculates the number of years between 2 dates using DateDiff. Here is the equation as it is:
BudgetedHQPCalc: Round(DateDiff("yyyy",[DateHired],[DateTerminated]),1)
What I would like this to do, is if the difference is, for example, 1.4, I want the number rounded down, if its 1.6 I want it rounded up, and if its 1.5, i want to use alternate rounding (1.5 down 2, 2.5 up to 3).
Is there an easy way to do this?
View 3 Replies
View Related
