Topics Search

Change font color in Query

Change font color in Query
Views: 97
Is it possible to change the text color in query view when it shows in datasheet view? I would like to change the text to red when the query runs.
Sponsored Links:

Similar posts...

 

Only change font fomat in select words within a memo field

Only change font fomat in select words within a memo field Icon
I would like to know if there is a way to change the font color only on select words or areas within a memo field and save the changes? So, if I want to either highlight or make some text red within a memo field how can I change the font format and keep it. This would only apply to the selected text within the memo field and the rest would remain the same default black color.

Is this an event procedure in VB that can be done?
 

Change color on text using column value?

Change color on text using column value? Icon
How do I use a value in a column to make a textbox change color? I can explain what I mean:
Right now when a value in a column is supposed to be disabled, I have made the font color grey instead of black using conditional formatting. But this only works with the object it's connected to. So how do I do if I want do use col1 to control the color of col2?
 

String Font and Color

String Font and Color Icon
I want to ask you gurus something, is it possible in vba to change the color and the font of a string?

e.g

Dim str as String

str = "Asking questions."

For that str to Change to Tahoma, or to Red Color.
 

Fonts and formatting

Fonts and formatting Icon
Learn the following topics: 1)Change the font, font size, or font color
2)Add formatting to your document by using the Mini toolbar
3)Apply bold, italic, or underline formatting to text
 

Change as per condition font color

Change as per condition font color Icon
I want when value is zero, font green. When value is less than zero, color red. When its bigger than zero font color should yellow.

Me.remain = Me.amount - Me.fpay - Me.spay - Me.tpay
If Me.remain.Value = 0 Then
Me.remain.ForeColor = RGB(0, 255, 255)
Else
If Me.remain.Value < 0 Then
Me.remain.ForeColor = RGB(0, 2, 255)
Else
If Me.remain.Value > 0 Then
Me.remain.ForeColor = RGB(0, 2, 255)
.....
 

Command buttom on click

Command buttom on click Icon
Friend I have many command buttons for example one I call command1 I want first click on that button fore color (font color) change into red and when I click again cancel color of font became again black.first part of question second part when I close form and open it save my color,I mean when button one is red color I close and open form it must red as it was select by click
 

Change font color to red

Change font color to red Icon
Below is the code that I am using.

.HTMLBody = .HTMLBody & "<B><U><Center>NEW CHANGES</B></U></Center>"

what this does is it bolds, underlines and centers the text NEW CHANGES as part of an email in the body of the email.

QUESTION: Can someone suggest me what can I do to make the font color RED. so that new changes appears to be red in color.

Kindly post the code or provide an example
 

Change font color in report

Change font color in report Icon
I have a form (titlepage) with a command button that prints a report (titlereport). The report has a text box that gets its data from a memo field in a table. I would like to add a drop-down box (fontcolor) on the form to allow the user to select the font color that would print in the report.
 

access 2007 some combo's won't keep same color formatting

access 2007 some combo's won't keep same color formatting Icon
I have searched for this, but can't find a solution that works.

I have 3 combo's all of which were created the same way, the 3 were added at a later time. When I added them I used the format painter to copy over the same "Look" of all the colors. well only the first of the 3 keeps the color you see when clicking the drop down.

In the detail section of my form I have it set to alternate color, on the combos that work, the font fore color remains the same as when it is not clicked, but the highlighted line of the selected choice will light up the font to RED. which is good. BUT. on the non working combo the font changes to BLACK for everything in the list, the color of the bar is correct but the selected shoice turns the Font to White! WTF, I have looked very closely at all the properties, there is no conditional formatting set. this is really annoying, I have my combos set to the perfect color
 

Conditional Formatting: change font color if value is 95%

Conditional Formatting: change font color if value is 95% Icon
I want to change the Font Colour on based of some condition e.g. If number is 100% and above then change numbers colour to Green
If it's above 95% and Less than 100% then Amber
If it's less than 95% then Red

And this need to be changed for a range e.g. D120

I'm not sure how to apply that condition.