Re: Add color to a field

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: fredg (fgutkind_at_example.invalid)
Date: 08/03/04 

Date: Tue, 03 Aug 2004 15:43:07 GMT

On Tue, 3 Aug 2004 08:31:48 -0700, Sara wrote:

> I need to make the font of one field show in Red if the
> value is before 1999, otherwise it needs to be Black. Can
> this be done?
>
> Thanks!
> Sara

Yes it can be done.
If you are using access 2000 or newer you can use the control's
Conditional Formatting property to change font color in both single
and continuous form view.

If you are using Access 97 or older you can, using code, change the
font color, but only in Single Form view. 

-- 
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Relevant Pages

  • Re: Using Image HyperlinkAddress to open a file with the location in a text box
    ... A "Continuous form" is no different from a single form seen many times where ... So on a single form you are likely only to ... Private Sub Image34_Click ... However, with an image, it opens the ...
    (comp.databases.ms-access)
  • Re: Control on form not always displaying data
    ... My form is already in single form view...what should I check next? ... Darhl ... > records in that continuous form, you often see that behavior because the ... >> I have a combo box control (cboDistrict) on my form that does not always ...
    (microsoft.public.access.forms)
  • Re: Calculating data in a form
    ... What are the names for the controls? ... Is this a single form with one record displayed, or a continuous form? ... Rick B ...
    (microsoft.public.access.forms)
  • using manifest problem
    ... i use manifest file in order to make XpStyle Button ... but i have to change font color of the button but i doesn't work when i use ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: Continuous form refresh/requery
    ... After they close the single form and I make the CONTINUOUS form automatically ... REQUERY, how do I get the record indicator to land on the NEW record in the ... But there IS an autonumber field. ...
    (microsoft.public.access.formscoding)