Link to home
Start Free TrialLog in
Avatar of Taras
TarasFlag 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.
ASKER CERTIFIED SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Taras

ASKER

Field is connected with front end (text box on form) I checked format there nothing in.
If you open the table directly, what do you see?

Jim.
Avatar of Taras

ASKER

That was the case Thank you a lot.
Avatar of Taras

ASKER

Thanks a lot