Allow only 4 digits in field

[funkygoorilla]

Hi,
I need to limit a field on a form, to allow the user to enter time in 24 hour format. But I need to set it to only allow 4 digits, including beginning with zeros. When I use something like Like "####" , it doesnt allow leading zeros. Anybody know how this can be done?
Thanks, FunkyG

[June7]

Review http://office.microsoft.com/en-us/ac...010096452.aspx

[funkygoorilla]

Hi June7, thanks for the link. Thats a keeper for sure. I wound up using 9### and it allows for zeros and limits the space to four characters. Thats what I needed!