Bolding Certain Records based on Fields Value

[Guest]

Using A2K.

I have a form that has all records in the table. I'd like to bold the
records in the form that have the value '21' in the Category Field and
non-bold if it contains anything else.

TIA

 

[Marshall Barton]

Using A2K.

I have a form that has all records in the table. I'd like to bold the
records in the form that have the value '21' in the Category Field and
non-bold if it contains anything else.

Use Conditional Formatting on each of the text boxes that
you want to be bold. Select the Expression Is option and
set the expression to [Category] = 21

 

[Guest]

Thanks Marshall, but I've looked at the properties of the text box and do not
see a "Expression Is" field.

Also, I've downloaded A2KConditionalFormattingVer27.mdb off of lebans.com
and have an example of the feature, but cannot find where in the database
it's pointing to the code to implement the change (all I could find was Has
Module = Yes in the CustomerYesNo form, but no pointer to which Module it is
using.).

Using A2K.

I have a form that has all records in the table. I'd like to bold the
records in the form that have the value '21' in the Category Field and
non-bold if it contains anything else.

Use Conditional Formatting on each of the text boxes that
you want to be bold. Select the Expression Is option and
set the expression to [Category] = 21

 

[Marshall Barton]

Conditional Formatting is not a control property, so it's
not surprising you couldn't find it in the property list


When the report is open in design view, select (click) the
text box, then use the Format menu and click on the
Conditional Formatting menu item. Then select the
Expression Is option in the drop down box on the left of the
CF window.
--
Marsh
MVP [MS Access]

Thanks Marshall, but I've looked at the properties of the text box and do not
see a "Expression Is" field.

Also, I've downloaded A2KConditionalFormattingVer27.mdb off of lebans.com
and have an example of the feature, but cannot find where in the database
it's pointing to the code to implement the change (all I could find was Has
Module = Yes in the CustomerYesNo form, but no pointer to which Module it is
using.).

Using A2K.

I have a form that has all records in the table. I'd like to bold the
records in the form that have the value '21' in the Category Field and
non-bold if it contains anything else.

Use Conditional Formatting on each of the text boxes that
you want to be bold. Select the Expression Is option and
set the expression to [Category] = 21

 

[Guest]

Thanks Marshall, that did the trick.

Conditional Formatting is not a control property, so it's
not surprising you couldn't find it in the property list


When the report is open in design view, select (click) the
text box, then use the Format menu and click on the
Conditional Formatting menu item. Then select the
Expression Is option in the drop down box on the left of the
CF window.
--
Marsh
MVP [MS Access]

Thanks Marshall, but I've looked at the properties of the text box and do not
see a "Expression Is" field.

Also, I've downloaded A2KConditionalFormattingVer27.mdb off of lebans.com
and have an example of the feature, but cannot find where in the database
it's pointing to the code to implement the change (all I could find was Has
Module = Yes in the CustomerYesNo form, but no pointer to which Module it is
using.).

Jay wrote:

Using A2K.

I have a form that has all records in the table. I'd like to bold the
records in the form that have the value '21' in the Category Field and
non-bold if it contains anything else.


Use Conditional Formatting on each of the text boxes that
you want to be bold. Select the Expression Is option and
set the expression to [Category] = 21