Macro Condition

[jenni_p]

Hi There -
I need to set up a macro to show a MsgBox if the
following control...
[Forms]![frm_prod_req]![folio]
is not evenly divisible by four.

I know this seems simple, but my brain is starting to
shut down in anticipation of the long weekend. I can't
figure out how to phrase the condition.
Thanks for any help!
Jenni

 

[jenni_p]

Okay, Sorry for the unecessary post, but I answered my
own question...
([Forms]![frm_prod_req]![folio])/4<>([Forms]!
[frm_prod_req]![folio])\4

Thanks anyway!

 

[Steve Schapel]

Jenni,

Your idea is a good one. This would also work...
[Forms]![frm_prod_req]![folio] Mod 4

--
Steve Schapel, Microsoft Access MVP

Okay, Sorry for the unecessary post, but I answered my
own question...
([Forms]![frm_prod_req]![folio])/4<>([Forms]!
[frm_prod_req]![folio])\4

Thanks anyway!

-----Original Message-----
Hi There -
I need to set up a macro to show a MsgBox if the
following control...
[Forms]![frm_prod_req]![folio]
is not evenly divisible by four.

I know this seems simple, but my brain is starting to
shut down in anticipation of the long weekend. I can't
figure out how to phrase the condition.
Thanks for any help!
Jenni
.