Evaluating Numbers on Reports

[velcrowe]

I have a report with a currency field storing dollar values. I would like to say that if the value in that field is less than $100 then hide or show another field. Can this be done?

ex. If me.salesvalue <100 then me.salessticker.visible = false

Thank you in advance

 

[WayneRyan]

vel,

Use Conditional Formatting to hide the field.

Wayne

 

[MSAccessRookie]

I have a report with a currency field storing dollar values. I would like to say that if the value in that field is less than $100 then hide or show another field. Can this be done?

ex. If me.salesvalue <100 then me.salessticker.visible = false

Thank you in advance

Maybe you want to something like this to toggle it based on the value?

If me.salesvalue <100 Then
me.salessticker.visible = False
Else
me.salessticker.visible = True
Endif