Format Font Formula

J

J

In my report I want to write a formula that says if a record has a Yes for
Field #2 [Listed], then font = bold for Field #1 [Record ID], else font =
regular for Field #1 [Record ID].
 
O

OfficeDev18 via AccessMonster.com

See the FontBold Property in the help file.

Sam
In my report I want to write a formula that says if a record has a Yes for
Field #2 [Listed], then font = bold for Field #1 [Record ID], else font =
regular for Field #1 [Record ID].
Click to expand...
 
F

fredg

In my report I want to write a formula that says if a record has a Yes for
Field #2 [Listed], then font = bold for Field #1 [Record ID], else font =
regular for Field #1 [Record ID].
Click to expand...

Access 2000 or newer?

In Design View, click on the [RecordID] control.
Select Format + Conditional Formatting
Set Condition1 To Expression Is
In the next box write:
[Listed] = -1 (if [Listed] is a Yes/No field
or
[Listed] = "Yes" (if [Listed] is a Text field.

Select the font Bold

Save the changes.
 
Top