How hard is it to format a detail line on a condition...

  • Thread starter robertfuschetto via AccessMonster.com
  • Start date
R

robertfuschetto via AccessMonster.com

We have a report with detail and summary footers. The users want the detail
row italicized when a certain condition arises...sort of Like Excel's
conditional formatting. So lets say I my detail consisted of food type, qty
and price. The user want me to have the line in italics whenever: foodtype =
beans. Can I easily d this?
 
F

fredg

We have a report with detail and summary footers. The users want the detail
row italicized when a certain condition arises...sort of Like Excel's
conditional formatting. So lets say I my detail consisted of food type, qty
and price. The user want me to have the line in italics whenever: foodtype =
beans. Can I easily d this?
Click to expand...

Here is one way.
Code the Detail Format event:
If Me![FoodType] = "Beans" Then
Me![qty].FontItalic = True
Me![Price].FontItalic = true
Me![FoodType].FontItalic = True
Else
Me![qty].FontItalic = False
Me![Price].FontItalic = False
Me![FoodType].FontItalic = False
End If

You can also use Conditional Formatting if you have Access 2000 or
newer.
 
R

robertfuschetto via AccessMonster.com

i DO HAVE acCESS 2000...WHERE IS THE CONDITIONAL FORMATING?
We have a report with detail and summary footers. The users want the detail
row italicized when a certain condition arises...sort of Like Excel's
conditional formatting. So lets say I my detail consisted of food type, qty
and price. The user want me to have the line in italics whenever: foodtype =
beans. Can I easily d this?
Click to expand...

Here is one way.
Code the Detail Format event:
If Me![FoodType] = "Beans" Then
Me![qty].FontItalic = True
Me![Price].FontItalic = true
Me![FoodType].FontItalic = True
Else
Me![qty].FontItalic = False
Me![Price].FontItalic = False
Me![FoodType].FontItalic = False
End If

You can also use Conditional Formatting if you have Access 2000 or
newer.
Click to expand...
 
F

fredg

i DO HAVE acCESS 2000...WHERE IS THE CONDITIONAL FORMATING?
We have a report with detail and summary footers. The users want the detail
row italicized when a certain condition arises...sort of Like Excel's
conditional formatting. So lets say I my detail consisted of food type, qty
and price. The user want me to have the line in italics whenever: foodtype =
beans. Can I easily d this?
Click to expand...

Here is one way.
Code the Detail Format event:
If Me![FoodType] = "Beans" Then
Me![qty].FontItalic = True
Me![Price].FontItalic = true
Me![FoodType].FontItalic = True
Else
Me![qty].FontItalic = False
Me![Price].FontItalic = False
Me![FoodType].FontItalic = False
End If

You can also use Conditional Formatting if you have Access 2000 or
newer.
Click to expand...
Click to expand...

Select each control, then click
Format + Conditional Formatting
Set Condition1 to
Expression Is
Set the expression to:
[FoodType] = "Beans"
 
D

Darrell Childress

Is it possible to make the text strikethrough using this method? I would
like to have the text striketrhough if [ShipFromPR] = Yes. Would I
just change FontItalic to FontStrikethrough or is that valid?
Thanks,
Darrell
We have a report with detail and summary footers. The users want the detail
row italicized when a certain condition arises...sort of Like Excel's
conditional formatting. So lets say I my detail consisted of food type, qty
and price. The user want me to have the line in italics whenever: foodtype =
beans. Can I easily d this?
Click to expand...


Here is one way.
Code the Detail Format event:
If Me![FoodType] = "Beans" Then
Me![qty].FontItalic = True
Me![Price].FontItalic = true
Me![FoodType].FontItalic = True
Else
Me![qty].FontItalic = False
Me![Price].FontItalic = False
Me![FoodType].FontItalic = False
End If

You can also use Conditional Formatting if you have Access 2000 or
newer.
Click to expand...
 
F

fredg

Is it possible to make the text strikethrough using this method? I would
like to have the text striketrhough if [ShipFromPR] = Yes. Would I
just change FontItalic to FontStrikethrough or is that valid?
Thanks,
Darrell
We have a report with detail and summary footers. The users want the detail
row italicized when a certain condition arises...sort of Like Excel's
conditional formatting. So lets say I my detail consisted of food type, qty
and price. The user want me to have the line in italics whenever: foodtype =
beans. Can I easily d this?
Click to expand...

Here is one way.
Code the Detail Format event:
If Me![FoodType] = "Beans" Then
Me![qty].FontItalic = True
Me![Price].FontItalic = true
Me![FoodType].FontItalic = True
Else
Me![qty].FontItalic = False
Me![Price].FontItalic = False
Me![FoodType].FontItalic = False
End If

You can also use Conditional Formatting if you have Access 2000 or
newer.
Click to expand...
Click to expand...

Sorry! Access does not support FontStrikeThrough.
 
R

robertfuschetto via AccessMonster.com

how about altering font color?
Is it possible to make the text strikethrough using this method? I would
like to have the text striketrhough if [ShipFromPR] = Yes. Would I
Click to expand...
[quoted text clipped - 22 lines]
Sorry! Access does not support FontStrikeThrough.
Click to expand...
 
Top