I have a lookup form made in access where users can search for specific records in a separate database. The two reference fields each consist of eight digit numbers. Any of these numbers less than 10000000 must have preceding zeros typed into search form, for example 00000345.
I was wondering if it is possible for users just to be able to type in 345 and for the preceding zeros to be automatically added based on the fact the numbers will always be 8 digits long.
Please can anyone provide me with some guidance? I have looked at a few ways round the problem but not managed to solve it.
Many thanks
Red
I was wondering if it is possible for users just to be able to type in 345 and for the preceding zeros to be automatically added based on the fact the numbers will always be 8 digits long.
Please can anyone provide me with some guidance? I have looked at a few ways round the problem but not managed to solve it.
Many thanks
Red