Macro Condition

  • Thread starter Thread starter jenni_p
  • Start date Start date
J

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 :)
 
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!
 
Jenni,

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

--
Steve Schapel, Microsoft Access MVP


jenni_p said:
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 :)
.
Click to expand...
Click to expand...
 
Back
Top