Problem With Continuous Forms

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

Hello. I'm using Access 2003. I'm having trouble with
some conditional formatting that I would like to do when
using a continuous form. Here's my code:

If (txtApplicationStatus.Value = 1) Then
txtApplicationStatus.ForeColor = 255
End If

I only want this to apply to the particular record that
meets this condition. The way it is now, if this
condition is met by any record, then all of them display
red. Any help would really be appreciated. Thanks.
 
Replace the code with conditional formatting.

In form design view, select the text box.
Choose Conditional Formatting on the Format menu.
 
Then I can only have three conditions, and It seems as if
they all have to have the same text color. I want a way
to do it in VB
 
As you found, coding in VBA applies the formatting to all rows.

It is possible to use the Format property of a text box that contains
numeric values to get 4 colours, if you arrange so the text box has
positive, negative, and zero values, but that is less useful than the
conditional formatting.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formating or Continuous Form Record Formatting 1
run a code based on the field conditional formatting back color 3
Conditional Formatting on Continuous Form 3
continuous form dosn't change 2
Hide duplicate rows on continuous form 8
RLI: Conditional formating and transparency 6
Conditional Text in textbox control of continuous form 5
Combobox Dropdown and Continuous Form Arrow Keys 2

Back
Top