Avatar of Taras
Taras
Flag for Canada asked on

MS Access 2013 field type short text default value

I have table in ms access 2013 in which I added a new filed short text type.
When I open table in datasheet view I can see that Access put value in that filed "No" . But when I open table in design view and check default value in the filed there is  noting there, no default value. From where this "No" is coming and how to remove it.
Microsoft Access

Avatar of undefined
Last Comment
Taras

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Jim Dettman (EE MVE)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Taras

ASKER
Field is connected with front end (text box on form) I checked format there nothing in.
Jim Dettman (EE MVE)

If you open the table directly, what do you see?

Jim.
Taras

ASKER
That was the case Thank you a lot.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Taras

ASKER
Thanks a lot