Format Font Formula

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

Guest

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].
 
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...
 
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.
 
Back
Top