Conditional Formatting For Currency/Euro

  • Thread starter Thread starter Davey
  • Start date Start date
D

Davey

I don't know if this is an appropriate post for the "Getting Started" user
group or not. If there's a more appropriate group, I'd be more than happy to
post there. Here's my situation. I have a access report with a "Earnings"
field. This field is set up for a "Currency" format. I also have a Country
field. If the Country is US I want the currency format used. If the Country
is Thailand, I want the "Euro" format used. How do I do this in the report?
Is this something that can be done or is this something that I need to
separate out into two seperate reports?

Thanks
 
I don't know if this is an appropriate post for the "Getting Started" user
group or not. If there's a more appropriate group, I'd be more than happy to
post there. Here's my situation. I have a access report with a "Earnings"
field. This field is set up for a "Currency" format. I also have a Country
field. If the Country is US I want the currency format used. If the Country
is Thailand, I want the "Euro" format used. How do I do this in the report?
Is this something that can be done or is this something that I need to
separate out into two seperate reports?

Thanks
Click to expand...

Is the [Country] field actually a Text datatype field?
In the Detail format event:
If Me![Country] = "Thailand" Then
Me![Earnings].Format = "Euro"
Else
Me![Earnings].Format = "Currency"
End If

If however, the [Country] field is a number datatype (you've used a
combo box with the ountryID as bound column, then

If Me![Country] = X Then
etc.
where X is the number value stored in the table that represents
Thailand.
 
Thanks!!!
fredg said:
I don't know if this is an appropriate post for the "Getting Started" user
group or not. If there's a more appropriate group, I'd be more than happy to
post there. Here's my situation. I have a access report with a "Earnings"
field. This field is set up for a "Currency" format. I also have a Country
field. If the Country is US I want the currency format used. If the Country
is Thailand, I want the "Euro" format used. How do I do this in the report?
Is this something that can be done or is this something that I need to
separate out into two seperate reports?

Thanks
Click to expand...

Is the [Country] field actually a Text datatype field?
In the Detail format event:
If Me![Country] = "Thailand" Then
Me![Earnings].Format = "Euro"
Else
Me![Earnings].Format = "Currency"
End If

If however, the [Country] field is a number datatype (you've used a
combo box with the ountryID as bound column, then

If Me![Country] = X Then
etc.
where X is the number value stored in the table that represents
Thailand.
Click to expand...
 
Back
Top