rows on tabular forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to change the color of a row or the properties of a field in a
row in a tablular form depending on a value in the row. I can do this with
reports. Is this posible in a form.
Thanks,
Stanley
 
If you have Access 2000 or later it can be done using Conditional Formatting.
Click on the control to be formatted to select it, then goto Formatting >
Conditional Formatting.

If the formatting of the ControlA is dependant on a value of ControlA, use
"Field Value Is" then enter the conditions for formatting, then set the
ForeColor/BackColor/Bold/Italic/Underline/Enabled options for that condition .


If the formatting of ControlA is dependant on a condition of, for instance,
ControlB, use "Expression Is" and then, for example, ControlB > 5, or
ControlB = "Completed" and then, once again, set the
ForeColor/BackColor/Bold/Italic/Underline/Enabled options.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
 
You must log in or register to reply here.

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

Tabular versus DataSheet 4
Filter tabular form by combo box 0
Conditional formatting of detail section in an access form 2
Changing rows in tabular form 1
Save, Delete Buttons in EditMode Form 2
Tabular Form - Move Cursor Down 2
Showing all data in tabular form boxes 2
Continuous Form: Change the color of one row 1

Back
Top