MS Access 2013 field type short text default value

Taras
Taras used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012
Commented:
Screen shots would be helpful, but at a guess, you have a yes/no format set on it somewhere.

Jim.

Author

Commented:
Field is connected with front end (text box on form) I checked format there nothing in.
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

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

Jim.

Author

Commented:
That was the case Thank you a lot.

Author

Commented:
Thanks a lot

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial