MsgBox 437 * 100

How then does one multiply two numbers in VBA?

Okay, you have to use CLng around one of the numbers. Solved.

It works for smaller values - I believe you're getting the overflow error because Access is trying to work it out using assumed data types (short integers, I think) that turn out inadequate for the task. The Clng (convert to long integer) function should make it work.

MsgBox Clng(437) * Clng(100)

Returns '43700'

You can also explicitly enforce a type on a number using one of the following suffixes...
? typename(1!)
Single
? typename(1@)
Currency
? typename(1#)
Double
? typename(1%)
Integer
? typename(1&)
Long

You can also explicitly enforce a type on a number using one of the following suffixes...
? typename(1!)
Single
? typename(1@)
Currency
? typename(1#)
Double
? typename(1%)
Integer
? typename(1&)
Long
Interesting. I was wondering if there was a way to do that. Thanks.