Change .Forecolor on the fly on Continuous Form??? 
Author Message
 Change .Forecolor on the fly on Continuous Form???

Howdy,

As the subject suggests, I want to change the text Forecolor on the fly
using a criteria.

Now I can do that if the form is a 'Single Form' default view using the
'Private
Sub Form_Current()', but not 'Continuous Forms' default view.

Any clues??

Many thanks.

Andrew McDonald



Fri, 03 Jan 2003 03:00:00 GMT  
 Change .Forecolor on the fly on Continuous Form???


Quote:
>Howdy,

>As the subject suggests, I want to change the text Forecolor on the fly
>using a criteria.

>Now I can do that if the form is a 'Single Form' default view using the
>'Private
>Sub Form_Current()', but not 'Continuous Forms' default view.

There's a solution on Stephen Lebans site:
http://www.lebans.com/formatbycriteria.htm

--
(remove a 9 to reply by email)



Fri, 03 Jan 2003 03:00:00 GMT  
 Change .Forecolor on the fly on Continuous Form???
On my web page, I have a free download that does exactly what you are
trying to accomplish. It changes the color of font in a continous form
based on criteria. Check it out and let me know if you have any
questions.

The download is "Set Criteria in a Continuous Form".

My web address is www.powerdatabases.com

Bill



Quote:
> Howdy,

> As the subject suggests, I want to change the text Forecolor on the
fly
> using a criteria.

> Now I can do that if the form is a 'Single Form' default view using
the
> 'Private
> Sub Form_Current()', but not 'Continuous Forms' default view.

> Any clues??

> Many thanks.

> Andrew McDonald

Sent via Deja.com http://www.deja.com/
Before you buy.


Fri, 03 Jan 2003 03:00:00 GMT  
 Change .Forecolor on the fly on Continuous Form???

Quote:

>Howdy,

>As the subject suggests, I want to change the text Forecolor on the fly
>using a criteria.

>Now I can do that if the form is a 'Single Form' default view using the
>'Private
>Sub Form_Current()', but not 'Continuous Forms' default view.

>Any clues??

>Many thanks.

>Andrew McDonald

If you using Access 97 and are looking to change the format of only
the current record in the continuous form, I don't believe this can be
done easily, if at all. (I never say something is impossible, I've
been proved wrong too often). I believe Access 2000 allows some
confitional formatting in continuous forms, but as I will not use A2K
at present due to it's "design enhancements", I don't know to what
extent.

In A97 any format change you make using Form_Current will affect every
record in the continuous form. Actually this behaviour is identical in
single forms, however as only one record can be viewed at a time it is
never apparent.

There have been some nice routines made available by some contributors
here (search Deja) which allow alternate back colors in continuous
forms to give a striped effect, however I have not seen examples of
the fore color being manipulated. (But I'd like to :o)

Wayne Gillespie



Fri, 03 Jan 2003 03:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Changing .ForeColor on the fly ?

2. Solution: Changing Forecolor for one Record on Continuous Subform

3. Solution: Changing Forecolor for one Record on Continuous Subform

4. Solution: Changing Forecolor for one Record on Continuous Subform

5. Continuous form, forecolor blues

6. Forecolor in one field of one record in a continuous form

7. Changing form labels and controls from a changing crosstab query, on the fly

8. Changing form labels and controls from a changing crosstab query, on the fly

9. CHANGING THE FORECOLOR OF A FORM IN THE DATASHEET MODE

10. Changeing text Forecolor on the fly on a Continuous Form??


 
Powered by phpBB® Forum Software © phpBB Group