I've been given a database, the guy who created it left about 5 years ago and I have two change the format for a column, as you can see in this pic:
The format is set so when you enter data it automatically enters like 999/9/9999
I want to remove the fixed slashes so it just reads like eg. 99999999
How do I do this? I've looked in various design views but nothing in there shows the format
Anyone able to help?
The format is set so when you enter data it automatically enters like 999/9/9999
I want to remove the fixed slashes so it just reads like eg. 99999999
How do I do this? I've looked in various design views but nothing in there shows the format

Anyone able to help?