IsNumeric Function in Macro Condition

[emerb]

Hello,
I'm having a problem validating the content of a text box called ProdAmnt. I
want to make sure that when the command button OK is enabled only when a
numeric value is entered into ProdAmnt.

So far i have:
Condition: [ProdAmnt].[Text]=""
Action: Set Value
Item: [cmd.ok].[Enabled]
Expression: [False]

Condition: [ProdAmnt].[Text]<>""
Action: Set Value
Item: [cmd.ok].[Enabled]
Expression: [True]

These conditions are working but I'm really struggling with the IsNumeric
function.

Can somebody point out the error of my ways please???

 

[Ken Snell [MVP]]

Action: Set Value
Item: [cmd.ok].[Enabled]
Expression: IsNumeric([ProdAmnt].[Text])