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

  • Thread starter Thread starter robertfuschetto via AccessMonster.com
  • Start date 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?
 
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.
 
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...
 
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"
 
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...
 
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.
 
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...
 
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]
You can also use Conditional Formatting if you have Access 2000 or
newer.
Click to expand...

Sorry! Access does not support FontStrikeThrough.
Click to expand...
Click to expand...

The Font Color is the ForeColor property.
[ControlName].ForeColor = what ever you want.
All you need do is look at a control's property sheet (on the Format
tab) to see what color properties you can change.
 
Back
Top