color in a continuos form

[SAC]

I have a continuos form that has date ordered and date shipped on it. If
the no fo days between the two controls is > X then I'd like a thrid control
to have red background.

All records on that column change rather than just the ones that meet the
criteria.

How can I change this?

Thanks.

 

[Larry Linson]

I have a continuos form that has date
ordered and date shipped on it. If
the no fo days between the two con-
trols is > X then I'd like a thrid control
to have red background.

All records on that column change rather
than just the ones that meet the
criteria.

Yes, that is the way continuous Forms work... there is really only one
Record on the form and the others are just copies but with data from
previous and following Records. If, in code, you change one control, you
change all.

In recent versions of Access, there has been a functionality called
"Conditional Formatting", however, that works on each one because it formats
the _data_, not the Form. I think that will accomplish your purpose.

As many people as have complained to Microsoft about this "feature" of
continuous forms view, I am surprised that they haven't changed it.

Larry Linson
Microsoft Access MVP

 

[Guest]

If your version of Access is 2000 or newer, then
Select The TextBox you want to format
In the menu bar click on Format + Conditional Formatting,
Set the condition and the color

 

[SAC]

Thanks!

Yes, that is the way continuous Forms work... there is really only one
Record on the form and the others are just copies but with data from
previous and following Records. If, in code, you change one control, you
change all.

In recent versions of Access, there has been a functionality called
"Conditional Formatting", however, that works on each one because it formats
the _data_, not the Form. I think that will accomplish your purpose.

As many people as have complained to Microsoft about this "feature" of
continuous forms view, I am surprised that they haven't changed it.

Larry Linson
Microsoft Access MVP

 

[SAC]

Thanks!

If your version of Access is 2000 or newer, then
Select The TextBox you want to format
In the menu bar click on Format + Conditional Formatting,
Set the condition and the color

 

[SAC]

Thanks!

Per SAC:

I have a continuos form that has date ordered and date shipped on it. If
the no fo days between the two controls is > X then I'd like a thrid control
to have red background.

All records on that column change rather than just the ones that meet the
criteria.

How can I change this?

I'm only on Access 2000 with a little time on 2003 and can't think of a way
unless you substitute one of the many hierarchical lists or grids for the form.

OTOH, you could add a field to the form that's dedicated to changing colors
depending on the status of that line. The field's .RecordSource would be a
numeric in the underlying table and it's .Format would be something like

"nnnn"[Green];"nnnn"[Black];[White];[White]

Check out Help|Format Property - Number and Currency Data Types for an
explanation of the syntax.


You *might* even get your desired result by making that field occupy the entire
line behind all the other fields, making all the other fields transparent, and
figuring out some Font/Character Value combo that filled the field with color
without showing anything else. Dunno...never tried that particular twist...

 

[(PeteCresswell)]

Per SAC:

I have a continuos form that has date ordered and date shipped on it. If
the no fo days between the two controls is > X then I'd like a thrid control
to have red background.

All records on that column change rather than just the ones that meet the
criteria.

How can I change this?

I'm only on Access 2000 with a little time on 2003 and can't think of a way
unless you substitute one of the many hierarchical lists or grids for the form.

OTOH, you could add a field to the form that's dedicated to changing colors
depending on the status of that line. The field's .RecordSource would be a
numeric in the underlying table and it's .Format would be something like

"nnnn"[Green];"nnnn"[Black];[White];[White]

Check out Help|Format Property — Number and Currency Data Types for an
explanation of the syntax.


You *might* even get your desired result by making that field occupy the entire
line behind all the other fields, making all the other fields transparent, and
figuring out some Font/Character Value combo that filled the field with color
without showing anything else. Dunno...never tried that particular twist...

 

[Arvin Meyer [MVP]]

MVP Stephen Lebans has written code available on his website that augments
conditional formatting and makes it available for Access 97.

http://www.lebans.com/
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[SAC]

Thanks.

MVP Stephen Lebans has written code available on his website that augments
conditional formatting and makes it available for Access 97.

http://www.lebans.com/
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access