Has anyone done this?

I'm trying to make a textbox called, Year, and it should be the
following:
- Allow Null Values
- Must be 4-digits (numbers), no less or not greater.

I tried using this logic:
If Len(Item.UserProperties("Year").Value) 0 And
Len(Item.UserProperties("Year").Value) 4 And
IsNumeric(Item.UserProperties("Year") = False Then
msgbox("Invalid. Must be 4-digits and no letters")
End If

For some reason it doesn't go through the IsNumeric() part. So I tried
searching for a Key event method and it's seems like Outlook doesn't
have such a thing... or I could be wrong.

Also, I've tried using a Number field, but it keeps default the value
with 0 which I can't get rid of.

Any suggestions? Any thoughts would be much appreciated.

See my response to your other post on this issue.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"nabeyaki-udon" wrote in message oups.com...
Has anyone done this?

I'm trying to make a textbox called, Year, and it should be the
following:
- Allow Null Values
- Must be 4-digits (numbers), no less or not greater.

I tried using this logic:
If Len(Item.UserProperties("Year").Value) 0 And
Len(Item.UserProperties("Year").Value) 4 And
IsNumeric(Item.UserProperties("Year") = False Then
msgbox("Invalid. Must be 4-digits and no letters")
End If

For some reason it doesn't go through the IsNumeric() part. So I tried
searching for a Key event method and it's seems like Outlook doesn't
have such a thing... or I could be wrong.

Also, I've tried using a Number field, but it keeps default the value
with 0 which I can't get rid of.

Any suggestions? Any thoughts would be much appreciated.