Forms :: Can Make A Color A String Value

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 Replies


ADVERTISEMENT

Modules & VBA :: How To Make One String Contains All Of A Column

Jul 25, 2013

i want to make a string that contains all of the fields in a column.

I have a table called UserSelectedComponentT with a column called ComponentName.

I want a string that is essentially all the different component names seperated by a " + " .

View 4 Replies View Related

General :: Evaluate String To Make Expression

Jan 11, 2013

This returns the correct value Debug.Print [myTable]![myField]

Why does this result in an error? Debug.Print Eval("[myTable]![myField]")

View 5 Replies View Related

Way To Make A Part Of A String That Is Calculated Into Currency Form?

Feb 28, 2012

I have a text box and currently this is my control source

="Testing " & [test]/3
test = 1000 so my text box reports:
Testing 333.333333333333

Is there a way to make it into a form like $333.33...Also is there a way to make [test]/3 come out in a money text form? like "Three hundred thirty three dollars and thirty three cents.

View 7 Replies View Related

Forms :: Find Hex Or RGB Value For Blue Color That Access 2010 Uses By Default For Buttons On Forms?

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

Forms :: Toggle Box That Changes Color Font?

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

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 7 Replies View Related

Forms :: Memo Field Has Color

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

Forms :: Changing Picture Color In Accordance With Value

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

Forms :: Color Coding A Box On Access Report

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

Forms :: Change Color With Conditional Formatting

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

Forms :: Conditional Formatting Field Color

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

Forms :: Checkbox Label Color Change

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

Forms :: Changing Color Of Text On Labels

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

Forms :: Label Border Color Incorrect

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

Forms :: Changing Row Color Depending On Value Of A Field?

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

Forms :: Expression To Change Color Of Text According To Date?

Jun 26, 2013

I am attempting to create an expression that will change the font to red if it is an overdue date. It will be on a form with the records showing.

My datebase is for entering, changing, and searching for information dealing with orientation dates, contacts, and associations. My data sheet holds the company name, employee name, date of orientation, due date (orientations are completed annually), contact employee, and status. I would like the date, when opening the form, to show red if it is past due. how to create an expresion to return the status as "Current" or "Overdue", as I am still unsure which method I want to use.

View 1 Replies View Related

Forms :: Button Back Color Change When Pressed

May 10, 2013

Is it possible that once the command button "Send Cost Request" in red is pressed it will change to green?

View 3 Replies View Related

Forms :: Conditional Formatting For Choices And Printing In Color

Aug 23, 2013

I have an access form that has a dropdown box list of 10 choices.

For example:

The form states please choose 1, 2, 3 or 4 then the choice should print in BLUE.

They choose 5, 6, 7 or 8 Then it need to print in RED.

So forth and so on.

I am sure there is a code I need to type in the conditional formatting area that would reflect if [1], [2], [3], [4] then I choose the red color.

I do not know how to use VBL or coding.

View 9 Replies View Related

Forms :: Color Text Field Based On Value Of Combo Box

Feb 28, 2015

I have a table named ColorValues with the following three fields:

- ID
- MunsellCode
- RGBValue

30 fields from another table called Color_Analysis are linked to the above with one to many relationships (I've already thought of other ways to normalize data, but this is the most efficient, so no need to go into this topic).

Now, I've constructed a form for Color_Analysis and all 30 fields recording color are included as combo boxes bounded on the ID in ColorValues and displaying the MunsellCode for the user. I've also created unbounded text fields next to the combo boxes and want to use them to display the color that the user selected in the ComboBox. The question is how do I do this?

Essentially I need a piece of code that picks up the value of the combo box (this is essentially the ID in ColorValues), looks up that value in the ID column of the ColorValues table and uses the corresponding RGBValue of the same table as the .BackColor for the unbounded text field.

View 8 Replies View Related

Forms :: Change Image Back Color On Click

Apr 30, 2014

I have images in my form, say, Image1 and Image2 . The default background color for all of them are white. If the user click image1, the background color has to be red. If the user click image2, the background has to change to red and the image1 retains its default color ( White ).

I have six images to loop through these. Image1 to image6.

View 8 Replies View Related

Forms :: Change Border Color Of Textboxes When They Have Focus

May 3, 2013

no problem about setting a different border color for a single textbox (or combobox or listbox) which has focus. How about to change, with a small and fast VBA code avoiding to write code for each textbox, the border color (ora other textbox properties) for a many controls in a form?

I tried using 'For each ctrl in Form....', but I got only bad results. All my control are within differente pages in TAB control.

View 14 Replies View Related

Forms :: Minus Value Conditional Formatting - Color Background

Feb 5, 2014

I would like to have a Positive value with a green Background and a Negative Value with a Pink Background.

View 3 Replies View Related

Forms :: Textbox Background Color Change Dependent On Value

Oct 3, 2013

I 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.

View 3 Replies View Related

Forms :: Conditional Color Formatting For Plus And Minus Number

Apr 18, 2014

how to have a different conditional colour formatting for a plus and a minus number

If the field value is a Plus Number
The background colour will be Green

If the field value is a Negative Number
The background colour will be Pink

View 6 Replies View Related

Forms :: ListBox - How To Change Selected Row Background Color

Mar 24, 2014

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 Related







Copyrights 2005-15 www.BigResource.com, All rights reserved