IsNumeric Function in Macro Condition

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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???
 
Action: Set Value
Item: [cmd.ok].[Enabled]
Expression: IsNumeric([ProdAmnt].[Text])
 
Back
Top