CURRENCY USE

  • Thread starter Thread starter Gilberto Lawas via AccessMonster.com
  • Start date Start date
G

Gilberto Lawas via AccessMonster.com

Hello,

I'm typing up an IF THEN statement that uses a currency field. What I'm
trying to say is

IF Limit = "$0.00" Then
[print the letter]

But it's not working. I think I'm using the wrong format for currency.
I've tried just "0.00", $.00, 0.00, 0# but nothing works.

Any advice?

r/s
G.Lawas
 
I believe a currency field is treated as a number, so you don't need the
dollar sign or the quotes. Try something like:
If Limit = 0 Then
 
Back
Top