PaquettePaul
Member
- Local time
- Today, 00:50
- Joined
- Mar 28, 2022
- Messages
- 107
So, I decided to change the database for my wheels up and down times from date fields to 4 character fields. I am using the routine that arnelgp provided for time validation with some modifications.
A statement is in there to determine if non numeric characters exist. The issue is that the Val(txtField) function returns a 0 if a non numeric character is found; however, the plus sign, negative, sign, and decimal place are recognized as being ok. Obviously, those special characters are not ok in a time field.
Does anyone know any easy method of detecting those characters as well?
A statement is in there to determine if non numeric characters exist. The issue is that the Val(txtField) function returns a 0 if a non numeric character is found; however, the plus sign, negative, sign, and decimal place are recognized as being ok. Obviously, those special characters are not ok in a time field.
Does anyone know any easy method of detecting those characters as well?