I have an access table whit a field propref of type text.
Reference numbers are automaticallyt added to this field when needed which are normally numbers. However sometimes text may be added.
Either way thery are always 7 characters long ie..
the problem i have is that when entered any leading zeros are lost in the table ie
0012345 is stored as
How can i store them as 0012345.
I have gone to the format property of the field and tried ##00000 which is what i use in excel but to no avail.