Continuous form problem

  • Thread starter Thread starter Maz
  • Start date Start date
M

Maz

I have a form which is a continuous form with about 12 fields in each
record. I would like to be able to unhide and show a red line through the
record if a certain criteria is met. The problem is I can make all the
monitory fields go to $0.00 and even show "CANCELLED" in a field all in the
same record but if put Me.lineShow.visible = True in my code it shows the
line in all records or alternately if I put Me.fieldname.forecolour = 255 it
also colours all fields of the same type in all records.
How Can I get the line to show or the colour in only the record that meets
the criteria I want?

Thanks in anticipation

Maz T
 
-----Original Message-----
I have a form which is a continuous form with about 12 fields in each
record. I would like to be able to unhide and show a red line through the
record if a certain criteria is met. The problem is I can make all the
monitory fields go to $0.00 and even show "CANCELLED" in a field all in the
same record but if put Me.lineShow.visible = True in my code it shows the
line in all records or alternately if I put
Click to expand...
Me.fieldname.forecolour = 255 it
also colours all fields of the same type in all records.
How Can I get the line to show or the colour in only the record that meets
the criteria I want?

Thanks in anticipation

Maz T
Click to expand...
Hi Maz, have you considered using conditional formating?

Luck & Happy New Year
Jonathan
 
Maz,

As you have discovered, changing properties of controls will change
them on a continuous form for all records. And Conditional Formatting
is not applicable to Line controls. One kludgy idea is to put a field
in the query that the form is based on, like this...
FakeLine: "--------------------------------"
and then put a transparent textbox bound to this field over the top of
the other controls, and use Conditional Formatting to change the Fore
Color.
Another somewhat similar idea is to use an unbound textbox over the
rest of the controls, with an expression that evaluates to true/false
in its controlsource. You didn't mention the "certain criteria", so
I'll just guess...
=[Status]="Cancelled"
You can then set the Format property of this control to:
;"---------------------------------";""

- Steve Schapel, Microsoft Access MVP
 
Back
Top