Access continuous form control setting

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

When using a continuous form, can the property of a
control be set for one record? Currently if conditionaly
setting a property, such as background color, all records
displayed reflect the change within the form.

Using VB code, I am trying to set a background color to
Red, Yellow, or Green, based on the value of the data for
a specific record.
 
Frank said:
When using a continuous form, can the property of a
control be set for one record? Currently if conditionaly
setting a property, such as background color, all records
displayed reflect the change within the form.

Using VB code, I am trying to set a background color to
Red, Yellow, or Green, based on the value of the data for
a specific record.
Click to expand...

You're right, change a property for yhe current record and
all the rows will display using the new setting. This is
beacuse the other rows are just images of the same controls.

In A2K+ you can use Conditional Formatting (Format Menu) to
display the control with up to 4 different colors.

In A97 or earlier, there are a few messy tricks you can use
to fake it, but I'd rather not go into if it's not
necessary.
 
Back
Top